Anyone have an RDLC Example with SQL Server 2008 R2
-
Hi, I am suspecting that my VS2010 is improperly building the .RDLC file to use with SQL Server 2008 R2, as I am getting an error that I can't explain or figure out. The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. If I rename the file to an .RDL it works, however I have to manually add the Data Source, DataSet and the SQL Query. Looking at the .RDLC file it doesn't look right as it has no data connections. Anyone have an example from VS2008 that works and you can send me via email, or paste into this link? Something simple like printing one field from the Northwind database. Much appreciated... :)
Glenn Sr. Software Specialist
-
Hi, I am suspecting that my VS2010 is improperly building the .RDLC file to use with SQL Server 2008 R2, as I am getting an error that I can't explain or figure out. The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. If I rename the file to an .RDL it works, however I have to manually add the Data Source, DataSet and the SQL Query. Looking at the .RDLC file it doesn't look right as it has no data connections. Anyone have an example from VS2008 that works and you can send me via email, or paste into this link? Something simple like printing one field from the Northwind database. Much appreciated... :)
Glenn Sr. Software Specialist
I'm guessing here as I do not have the definitive answer. I believe the 'C' stands for client, that is the RDL will not be published via reporting services. Therefore in the 'C' version of the RDL it expects the 'C'lient to supply the data, whereas the published format retains the data connections. Client format is for embedding in your application and your app should supply the dataset/table to service the report.
Never underestimate the power of human stupidity RAH