Click here to Skip to main content
15,890,557 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have edited SQL 2005 Reports using the SQL 2008 editor, but new reports won’t be able to be uploaded to the SQL 2005 report server via Report manager.So what to do?


Error is

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. (rsInvalidReportDefinition)
Posted

1 solution

Yes, the error is fine and you would not be able to do it.

Once a report is made/edited in SQ: 2008, ten you wont be able to use it or run it in 2005. There are lots of changes in report schema and controls.

Apart from above namespace issue there will be controls issue also. Like Table in 2005 is a normal table but in 2008 it is a Tablix.

In order to get back the report working in 2005, you need to revert back changes such that the namespace and controls are compatible to 2005.
 
Share this answer
 
Comments
deepak thomas 29-Sep-10 4:49am    
Thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900