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 6. Report Project property in SQL Server 2008 Project
This workaround fixed the Error.
Happy Learning!!!
No comments:
Post a Comment