Sql server 2008 R2 reporting service support sql server 2005 report
I export report rdl files from sql server 2005 reporting service and import them into sql server 2008 r2 from Report Manager. Import were successfully, but when run it, I got error and I am attaching error. 2008 support rdl report in 2005? Do I need to do any kind of convert ? If yes, how to do it error: an error occurred during rendering of the report. (rrRenderingError) could not load file or assembly 'Microsoft.ReportingServices.RPLObjectModel, Version=1.0.0.0, Culture=neutral,PublickeyToken=89645dcd8080cc91' or one of its dependencies. Access is denied. thanks Gary
December 28th, 2010 9:40pm

The scheme for 2005 is different from 2008R2. You cannot directly upload the SSRS2005 built reports to SSRS 2008R2 Report manager. If you have a project where you had built your SSRS 2005 reports, then I suggest you to open the same project with BIDS 2008 R2. This will automatically convert the reports to SSRS 2008. Even if you don't have the project, I suggest you to open the 2005 built reports using BIDS 2008R2. You can redeploy them to Report manager 2008 R2. Hope this helps..Chaitanya
Free Windows Admin Tool Kit Click here and download it now
December 29th, 2010 1:22am

Hi Chaitanya, Thanks for your help. I have lost some source codes. Is there any way that I can export all reports ,datasource and data model from sql server 2005, to one folder and then use visual studio 2008 to retrieve/load these files, then deploy to sql server 2008. thanks Gary
December 29th, 2010 11:51am

You can save the rdl files to your file system manually, and then reopen them within BIDS 2008 R2. It shouldn't be a major task if you have few reports. You can save each report, one after the other. If you have too many reports, and you want to automate the export of all the RDLs, then you can try using the Reporting Services APIs and write a small utility to export all the RDL files. How to automate this? Iterate across all the report items: http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.listchildren.aspx and then Save the RDL file to file system: http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.getreportdefinition.aspx Hope this helps!!Chaitanya
Free Windows Admin Tool Kit Click here and download it now
December 29th, 2010 12:06pm

You can save the rdl files to your file system manually, and then reopen them within BIDS 2008 R2. It shouldn't be a major task if you have few reports. You can save each report, one after the other. If you have too many reports, and you want to automate the export of all the RDLs, then you can try using the Reporting Services APIs and write a small utility to export all the RDL files. How to automate this? Iterate across all the report items: http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.listchildren.aspx and then Save the RDL file to file system: http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.getreportdefinition.aspx Hope this helps!!Chaitanya
December 29th, 2010 12:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics