July 5, 2010 at 9:49 am
Hi all,
I development several reports using the VS2008 and now was alerted that the client use the SQL server 2005 and when he open my project show him the error message: "[rsInvalidReportDefinition] 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."
I tryed create one new project on VS2005 and import the RDL file, but i have the same error. Its possible convert my reports developed in VS2008 to open in VS2005?
Thanks all.
July 7, 2010 at 10:18 am
Hi giulianocardoso,
I think that SSRS 2000,2005 and 2008 reports all use different versions of the Report Definition Language.
Whilst Visual Studio 2008 \ BIDS 2008 will happily upgrade reports written in RDL 2005 (or even RDL 2000 for that matter) to RDL 2008, I do not believe that there is any downgrade type functionality to convert an RDL 2008 report to an RDL 2005 or RDL 2000 format.
Unfortunately I think that you need to recreate your reports from scratch within VS2005 or BIDS2005 in order to make them compatible with SSRS 2005.
July 7, 2010 at 11:20 am
Hi andy, thank you for your feedback.
I really had which develop my reports again in VS2005 because this downgrade is not possible because of differences in RDL language between versions.
Thanks!
November 6, 2010 at 12:51 am
its possible to convert 2008 RDL to 2005 version with a tool....Check this out...
http://stackoverflow.com/questions/1097690/converting-sql2008-rdl-file-to-sql2005
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
November 19, 2010 at 8:19 am
amarsale (11/6/2010)
http://stackoverflow.com/questions/1097690/converting-sql2008-rdl-file-to-sql2005%5B/quote%5D
Correct me if I'm wrong, but I don't believe you've pointed out a tool. The only thing I saw on that page was a link to the RDL file specs for 2008 and 2005 RDL files. You got my hopes up!
November 19, 2010 at 1:33 pm
Hi guys,
Like i sais, i solved this problem rebuilding my project in SSRS 2005, but i had the curious to access the link posted by our coleague amarsale, i don't know if i understand right, but only there are two documents about rdl specification and one post about the tool, but has not any details about this tool (will be a legend?)
anyway i thank everyone who posted here.
November 19, 2010 at 2:11 pm
i have purchased and used this tool 4 converting 2008 rdl to 2005 version. it's a great tool 4 reducing ur work:-)
i contacted him through following link ---
his name is AmarSale and he is a nice guy. he gave me a demo of the utility tool before purchasing it.
see yaa...
October 22, 2012 at 7:38 am
It is possible. For more information about the tool to convert SSRS 2008 report to 2005 version, please visit : www.applybi.com
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 23, 2012 at 7:50 am
I think Report Services Scripter will do what you need. See[urlhttp://www.sqldbatips.com/showarticle.asp?ID=62[/url]
If there are any items in your report that do not have an equivalent in the older version of SQL Server, SSRS Scripter may not help you, but if you have used items common to both versions it should convert OK. However, you should plan to test all reports converted by any automated tool.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply