SSRS rdl on Winforms Report Viewer using SQL Express
I am attempting to adapt a report created in SQL Reporting Services 2008 (Server Report).
The distributed client is a Windows Application (C#) with a local SQL Express 2005 database that has a matching schema (at least for this report).
I am having problems attempting to convert the rdl to a rdlc which can be used with the Report Viewer Control.
Has anyone attempted to do this or have knowlege that can help?
The distributed client is a Windows Application (C#) with a local SQL Express 2005 database that has a matching schema (at least for this report).
I am having problems attempting to convert the rdl to a rdlc which can be used with the Report Viewer Control.
Has anyone attempted to do this or have knowlege that can help?
ASKER
This is the process I am attempting to follow, however when I try to build the project after the report is added, I get an error that the namespace is invalid and can not be upgraded:
The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.
Googling for a couple of days has pointed to Reportviewer incompatibility, but the solution is supposed to be the rdlc conversion you pointed out.
Still, the project will not build.
The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.
Googling for a couple of days has pointed to Reportviewer incompatibility, but the solution is supposed to be the rdlc conversion you pointed out.
Still, the project will not build.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
zadeveloper is correct that you can't use a 2008 developed report on a 2005 RS instance. You can use data from any database, but the underlying report definition changed significantly from 2005 to 2008 and you can not go backwards in compatibility on them.
As promised:
Hardware and Software Requirements for Installing SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143506.aspx
Hardware and Software Requirements for Installing SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143506.aspx
ASKER
Thanks You. This saved me wasted time.
No Problem, + good luck
http://msdn.microsoft.com/en-us/library/ms252109(VS.80).aspx