Post reply

rsInvalidReportDefinition error when trying to deploy AdventureWorks sample reports

  • March 6, 2012 at 5:59 pm

    #265549

    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!

  • March 21, 2012 at 7:12 am

    #1462115

    Try using http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition/

    as the namespace and see if you get the same results.

  • December 31, 2012 at 4:32 am

    #1572483

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply