I am at work - I am a business analyst. Today, in SQL Server Reporting Services, I came across an issue that you might also have. If a report is opened and saved in SSRS 2010 - an error occurs when trying to re-open it in SSRS 2008. The report will only show the HTML code when opened in VS2008 - Solution Explorer.
The following steps will fix this issue:
1. I was trying to open an SSRS report in VS 2008 that had been built on a laptop that was using VS2010. The error message stated something about having an incorrect namespace - and only the HTML showed:
The following line was the clue to the issue - xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition"
Original line in the xml code:
<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">
I copied the following code from a report that was working – into the xml -
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
And replaced the code in my report – one line as above.
2. The next error that appeared was that there was no object <Report Sections>
I went through the xml version of the report and deleted the two tags – and NOT the code inside – leaving the Body as is:
<Report Sections>
<Report Section>
</Report Section>
</Report Sections>
And it worked! The report opened normally in the SSRS 2008 interface.
