You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server - SQL Server with Mr. Denny
Home > IT Blogs > SQL Server with Mr. Denny > You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server
>>VIEW ALL POSTS  

SQL Server with Mr. Denny

« How to setup SQL 2008 BIDS to use VB.NET as the default scripting language
SQL Server Experts: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost »
Jul 28 2008   11:00AM GMT

You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server



Posted by: mrdenny
SQL Server 2005, RDL, SQL Server 2008, SSRS

SQL 2008 and SQL 2005 use different RDL namespaces and so they pretty much aren’t compatible.  You can edit SQL 2005 Reports using the SQL 2008 editor, but new reports won’t be able to be deployed to the SQL 2005 report server.

With enough major editing of the SQL 2008 report you can convert it to a SQL 2005 report.

In a future post (you can read this as, as soon as I figure out just what editing needs to be done) I’ll cover what editing needs to be done to the SQL 2008 RDL to make it run within a SQL 2005 Report server.

This is going to come in handy as you can’t have SQL 2005’s UI and SQL 2008’s UI installed on the same machine.

Denny

AddThis Social Bookmark Button     Comment     RSS Feed     Email a friend

Comment on this Post


You must be logged-in to post a comment. Log-in/Register

Marlin7  |   Jan 5 2009   5:48AM GMT

I went through the trouble and paid the cost of upgrading to VS2008 and installing the BIDS of SQL2008, only to find i can’t upload SSRS2005 reports which i edited in VS/BIDS2008. So i sure would love to see a workaround!

-On a hunt.


 

Marlin7  |   Jan 5 2009   5:56AM GMT

This is the error:
An error occurred during local report processing. The definition of the report ‘Main Report’ is invalid. The report definition is not valid. Details: The report definition has an invalid target namespace ‘http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition’ which cannot be upgraded


 

TStat  |   Oct 19 2009   4:30PM GMT

I am currently running BIDS for 2008 and Visual Studio for 2005 on the same machine without any issues. I do it here at work as well as my laptop at home. I can write reports for SSRS 2005 or 2008 depending on which server I need to publish to. I personally wouldn’t bother with trying to hack a 2008 report down to work in 2005 as the reason I write in 2008 is to take advantage of 2008’s features. You CAN also simply publish a report written in 2005 to a 2008 report server as it is backwards compatible.


 

mrdenny  |   Oct 22 2009   7:57PM GMT

The issue comes when you only have BIDS 2008 and VS 2008 installed and you need to create a report for a SQL 2005 server.

You can push a SSRS 2005 report to a 2008 server without issue, but going the other way doesn’t work.