Geeks With Blogs

News

DevJef's Mumbo-Jumbo «There's a bit of SQL in all of us»

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.

Posted on Monday, September 26, 2011 3:06 PM | Back to top


Comments on this post: Deploying Report Builder 3.0 reports on 2005 Report Server

# re: Deploying Report Builder 3.0 reports on 2005 Report Server
Requesting Gravatar...
Thanks it works
Left by lean on Mar 08, 2012 7:11 PM

# :)
Requesting Gravatar...
Gracias
----------
Thank you
Left by Carlos on Mar 12, 2012 7:58 PM

# re: Deploying Report Builder 3.0 reports on 2005 Report Server
Requesting Gravatar...
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.
Left by karthick on Jun 04, 2012 2:23 PM

# re: Deploying Report Builder 3.0 reports on 2005 Report Server
Requesting Gravatar...

im getting following error in design. (2008 BID)
Deserialization failed: Requested value 'Integrated' was not found. Line 7, position 36.
Left by karthick on Jun 04, 2012 2:37 PM

# re: Deploying Report Builder 3.0 reports on 2005 Report Server
Requesting Gravatar...
@karthick: I've contacted you by e-mail. Please read my tips to fix your issue ;)
Left by DevJef on Jun 04, 2012 2:47 PM

# re: Deploying Report Builder 3.0 reports on 2005 Report Server
Requesting Gravatar...
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.
Left by kaczmar2 on Jan 16, 2013 12:36 AM

# re: Deploying Report Builder 3.0 reports on 2005 Report Server
Requesting Gravatar...
Thank you Very Much
Left by Raj on Mar 09, 2015 8:05 AM

Your comment:
 (will show your gravatar)


Copyright © DevJef | Powered by: GeeksWithBlogs.net | Join free