SQL Server with Mr. Denny

Jul 28 2008   11:00AM GMT

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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

10  Comments on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Marlin7
    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.
    0 pointsBadges:
    report
  • Marlin7
    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
    0 pointsBadges:
    report
  • TStat
    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.
    0 pointsBadges:
    report
  • Denny Cherry
    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.
    66,335 pointsBadges:
    report
  • AmarSale
    Hi mrdenny, I have a tool which converts 2008 rdl to 2005 so that they can be deployed on Sql 2005 report server. please free to contact me on : amarsale@gmail.com Thanks & Regards, Amar Sale.
    35 pointsBadges:
    report
  • Bandari
    Hi Amar Sale, I've seen your reply in this mail chain. Can I contact you on your mail amarsale@gmail.com for getting tool. I really need it to convert 2008 rdl files to 2005. Thanks in advance. Bandari
    0 pointsBadges:
    report
  • AmarSale
    Hi Bandari, Yes. please contact on my email : amarsale@gmail.com. Thanks & Regards, Amar Sale
    35 pointsBadges:
    report
  • AmarSale
    Hi BGabriel, Yes. please contact on my email : amarsale@gmail.com. Thanks & Regards, Amar Sale
    35 pointsBadges:
    report
  • MrPryor
    Currently I am running a 2005 SSRS Website, and 7/9 of my reports are done in 2005, and when I try access the 2 reports in 2008, it prompts me to enter my user name and password again, with this converter, will it solve this issue? I need a solution to get around the authentication of 2008 (with its extra level of authentication) which is not in 2005 SSRS, will this help with this issue, I have looked everywhere and there doesn’t seem to be a solution to this problem. Please help on this. i have been looking for 2 months and have been unsuccessful, any solutions or suggestions will be appriciated. Please contact me on Grant@bmi.co.za
    15 pointsBadges:
    report
  • AmarSale
    Please visit the downloads section of www.ApplyBI.com to get information about the tool for converting 2008 rdl (SSRS Report) to 2005
    35 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: