"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

September 07, 2011

SSRS 2008 Deployment Error - [rsInvalidReportDefinition] The report definition is not valid. Details: The report definition has an invalid target namespace

Learning's on fixing Error[rsInvalidReportDefinition] The report definition is not valid.  Details: The report definition has an invalid target namespace

Step 1. Developed a SSRS Report in SQL Server 2008 R2 Environment and Tried Deploying in SQL Server 2008 Environment

Step 2. Got below Error
[rsInvalidReportDefinition] 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.

Step 3. Below link was useful

Step 4. Based on one of the recommendations, Set the Target as SQL Server 2008, Build the Project, Copy the generated rdl file into 2008 target environment
  • In SSRS 2008 R2, open the solution, right click on the project file name, and click properties. And the set the TargetServerVersion to SQL Server 2008.
Step 5. Report Project property in SQL Server 2008 R2, You can see target version set to SQL Server 2008


Step 6. Report Project property in SQL Server 2008 Project


This workaround fixed the Error.

Happy Learning!!!

No comments: