January 2, 2013 at 11:08 am
I am using SSRS 2008r2 and importing the rdl into SharePoint 2010.
The rdl worked fine and when imported into SharePoint 2010, it also worked without any problems.
A new requirement was given to see the Excel tab names when exporting the spreadsheet. I added a variable in the Tablix PageName to allow the tabs to have their individual name. It worked fine as a standalone report.
The xml headers changed From
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
To
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
And saw this error message:
I imported the rdl into SharePoint 2010 and attempted to add the Data Source into Manage Data Sources
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: f0a9d2f6-a59b-4207-96a1-bcae60fd396e
Date and Time: 1/2/2013 1:01:38 PM
Can someone help me to fix this problem?
May 28, 2013 at 2:05 pm
I'm having the exact same issue but I encounter it while trying to upload the report to SQL Server Report Manager.
When modify the properties of a tablix and add anything to the 'PageName' property, it changes my
report definitions from
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
to
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
Does anyone have a solution to this?
p.s.
Changing the definition back to
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
does not fix the issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply