SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Its possible convert SSRS report developed from VS2008 to VS2005


Its possible convert SSRS report developed from VS2008 to VS2005

Author
Message
giulianocardoso
giulianocardoso
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 160
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.
Andy Hogg
Andy Hogg
Right there with Babe
Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)

Group: General Forum Members
Points: 741 Visits: 1016
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.
giulianocardoso
giulianocardoso
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 160
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!
H4K
H4K
SSC Veteran
SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)

Group: General Forum Members
Points: 249 Visits: 567
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
dbendixen
dbendixen
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 17
amarsale (11/6/2010)
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


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!
giulianocardoso
giulianocardoso
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 160
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.
manu.marathimanoos
manu.marathimanoos
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 5
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 ---
http://itknowledgeexchange.techtarget.com/sql-server/you-cant-deploy-a-sql-2008-ssrs-report-to-a-sql-2005-ssrs-server/

his name is AmarSale and he is a nice guy. he gave me a demo of the utility tool before purchasing it.

see yaa...
H4K
H4K
SSC Veteran
SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)

Group: General Forum Members
Points: 249 Visits: 567
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
EdVassie
EdVassie
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6080 Visits: 3866
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search