If you get an error like the following when deploying a report to SQLServer ReportingServices 2008, it is usually because the report was created in a design environment setup for SQL Server 2008 R2, but your server is SQL Server 2008 R1 (I know, that’s not what it’s called, but you know what I mean).
The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)
To fix this error:
- Edit the report RDL (Code View as it is called in BIDS).
- Replace the Report header with the following:
- Remove the <ReportSections> and <ReportSection> tags from the report. Note, remove the tags only. Leave all content inside the tag. Don’t forget to remove the closing tags for each of these.
- Save the report. You should now be able to upload it.