Hi there,
I'm working on a scenario where a number of smartclients at distributed locations will connect to a central reporting services server. We are replicating data onto a SQL Express machine (on Windows XP) at each distributed location, and are hoping to migrate some of the day-to-day reporting onto Express at a later stage when it supports SSRS.
I have a number of questions requiring some clarification to make sure this will be feasible:
- Will the Express edition support personalized reports and the 'My Reports' folder in Report Manager per user Will users be able to upload reports onto the Express SSRS which they have designed using Report Builder launched from the central SSRS
- Can the ReportViewer controls on a smartclient be used to view these reports on the Express SSRS
- Are there any licensing costs involved in:
a) Distributing an application using the ReportViewer control
b) Running SSRS on the Express machine
c) Connecting multiple clients to SSRS on the Express machine (CAL )
SSRS on SQL Server 2005 Express
topnotch
Answers on your questions:
a) the RDL spec is the same
b) the web service API is the same
-- Robert
Kylin Ming
Wow you learn something new every day. Now I'm looking forward to seeing what can be done with it. They really are attacking Crystal Reports head-on. This is good in regards to engendering innovation. However with MS offering a free version, they could find themselves in the same troubled waters that they did with the whole Netscape legal war.
I can answer one question for you. The Winform (and ASP.net) ReportViewer Control is freely redistributable.
foxbuilder
Yes, there has been an announcement that you missed. Microsoft plans on including a lightweight SSRS in a version of Express called SQL Server 2005 Express with Advanced Services or something like that, around the same time as SP1.
Expected features: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
Lifeng
frustrated steph
Anybody have links with Microsoft's team for SQL Express It would be great to have some clues from an insider
I'm assuming the SSRS on Express will a) support the same RDL spec as Enterprise and b) host the same basic web service API such that a client application could switch between Enterprise and Express servers and still work the same.