DevJef's Mumbo-Jumbo

«There's a bit of SQL in all of us»


News


How fun is it to use new software? As a developer you always want to use the latest software, and in many cases it’s backwards compatible. This (unfortunately) isn’t the case with Report Builder 3.0 and SQL Server 2005 Reporting Services. This is a “by design” issue, but it’s such an annoying “feature”. If you try to deploy a Report built in RB 3.0, you will get the error:

 

"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)"

 

In most cases you will copy-paste the tables or objects from RB 3.0 to the Business Intelligence Development Studio (BIDS), and save it again. But sometimes you just want to take the shortcut, and that is possible as well. As always, I have to mention that I don’t guarantee anything, but it worked for me several times.

 

The first step is to open the .RDL file with a text editor, and replace the following line of XML:

 

<Report xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner” 
xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition“>

 

with:

 

<Report xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner”
xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition“>

 

Step two is removing a set of nodes in the RDL, that is not supported by versions older then Report Server 2008:

 

<ReportSection>     <ReportSections>

 

 

And it’s closing tags:

 

    </ReportSection>
</ReportSections>

 

Don’t remove the text inside these tags, only remove the tags themselves!!!

 

If you follow these steps, you will be able to deploy a “new” Report to an “old” Report Server without weird copy-paste actions.


Comments

Gravatar # re: Deploying Report Builder 3.0 reports on 2005 Report Server
Posted by lean on 3/8/2012 7:11 PM
Thanks it works
Gravatar # :)
Posted by Carlos on 3/12/2012 7:58 PM
Gracias
----------
Thank you
Gravatar # re: Deploying Report Builder 3.0 reports on 2005 Report Server
Posted by karthick on 6/4/2012 2:23 PM
While i m do above step i getting error
[rsInvalidReportDefinition] The report definition is not valid. Details: '”' is an unexpected token. The expected token is '"' or '''. Line 2, position 18.
Gravatar # re: Deploying Report Builder 3.0 reports on 2005 Report Server
Posted by karthick on 6/4/2012 2:37 PM

im getting following error in design. (2008 BID)
Deserialization failed: Requested value 'Integrated' was not found. Line 7, position 36.
Gravatar # re: Deploying Report Builder 3.0 reports on 2005 Report Server
Posted by DevJef on 6/4/2012 2:47 PM
@karthick: I've contacted you by e-mail. Please read my tips to fix your issue ;)
Gravatar # re: Deploying Report Builder 3.0 reports on 2005 Report Server
Posted by kaczmar2 on 1/16/2013 12:36 AM
Thanks this is a simple fix when you need to backlevel an .rdl that was developed in SSRS 2008 R2 and need to deploy on SSRS 2008 R2.
Post A Comment
Title:
Name:
Email:
Comment:
Verification: