SQL Server Express with Advanced Services -- ? on limitations



Hi,

Looking through the brief on SQL Express/AS the following line is included :

- Run SQL Server Reporting Services reports on local relational data.


Does this mean that if you have an application using this version of SQL, that only the machine that has the SQL sever installed can run the reports(that being the reports are only local to clients on the same machine) ?

I have an application where their are 5 users on PC connected to the application (normal Client Server setup), and would like them to be able to access reports and print them as well.

THanks

.



Relevant Pages

  • A little OT - Quite a rant on microsoft.public.sqlserver.olap
    ... SQL authentication doesn't work for SQL Server to anywhere. ... reports in ADP; but somehow it's not getting traction. ... thru in order to create forms and reports against a database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: why>?
    ... MDB are a useful learning tool ... I used them for several years before moving to SQL. ... We've got the most exciting pivotTables anywhere. ... it's each to share reports with others; copy reports; duplicate ...
    (microsoft.public.excel)
  • Re: Faircom c-Tree Server vs. Relational DBMS
    ... Our products were very reliable in terms of how the database ... SQL was used for building and upgrading the ... to process reports that take several hours to run. ... what database tools to use) that are dictated by management ...
    (comp.databases)
  • Re: View or Not Views
    ... SQL Server use the tempdb database to store temporary results and do the required calculations, but its a per-session "table", and you can't access or use these result directly. ... If you really want to access the database in your reports and you always access aggregated data, then create pre-aggregated tables to store the result and use these tables instead of you 500Gb table. ...
    (microsoft.public.sqlserver.olap)
  • Re: Using an MS Access Project with an OLE DB Data Source
    ... As far as SQL ... they can create their own queries and reports. ... you can link to both Oracle and SQL Server databases in the same mdb ...
    (microsoft.public.access.externaldata)