rsInvalidReportDefinition error when trying to deploy AdventureWorks sample reports

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » rsInvalidReportDefinition error when trying...

rsInvalidReportDefinition error when trying to deploy AdventureWorks sample reports

Rate Topic

Display Mode

Topic Options

Author

Message

jasondhindsa

Posted Tuesday, March 06, 2012 5:59 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 08, 2012 1:49 PM
Points: 5, Visits: 17

Hi,

I have been trying to deploy the AdventureWorks report samples through BIDS, but I am getting the following 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. C:\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\Report Samples\AdventureWorks 2008R2 Sample Reports\AdventureWorks 2008R2\Employee_Sales_Summary_2008R2.rdl

I have SQL Server 2008 R2 installed. I'm new to BI/SQL Server 2008, so I'm not sure what other information needs to be provided.

Please help!

Post #1262630

Tee Time

Posted Wednesday, March 21, 2012 7:12 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:33 AM
Points: 321, Visits: 240

Try using http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition/
as the namespace and see if you get the same results.

Post #1270140

bob_armstrong4

Posted Monday, December 31, 2012 4:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, June 03, 2013 11:07 AM
Points: 27, Visits: 98

I tried that and it did not work.

My issue started to happen when I added a value in Tablix (Page Name), so that when I export the report as an EXCEL file each tab will have a specific name. It works fine when I run the report as a standalone report. It all fails when I try to open the rdl file when it resides in SharePoint 2010.

Here are my error messages;

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)

System.Web.Services.Protocols.SoapException: 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.
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetItemDataSources(String Item, DataSource[]& DataSources)
at Microsoft.ReportingServices.WebServer.ReportingService2006.GetItemDataSources(String Item, DataSource[]& DataSources)
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: 34f97b8b-a52c-4493-a6cb-3a1755db3dff
Date and Time: 12/31/2012 5:19:59 AM

Post #1401355

« Prev Topic | Next Topic »

Permissions