Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Its possible convert SSRS report developed from VS2008 to VS2005 Expand / Collapse
Author
Message
Posted Monday, July 5, 2010 9:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 1:48 PM
Points: 7, Visits: 144
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.
Post #947570
Posted Wednesday, July 7, 2010 10:18 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 19, 2014 1:34 AM
Points: 494, Visits: 862
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.

Post #948679
Posted Wednesday, July 7, 2010 11:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 1:48 PM
Points: 7, Visits: 144
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!
Post #948723
Posted Saturday, November 6, 2010 12:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
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
Post #1016855
Posted Friday, November 19, 2010 8:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 15, 2011 9:42 AM
Points: 3, 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!
Post #1023554
Posted Friday, November 19, 2010 1:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 1:48 PM
Points: 7, Visits: 144
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.
Post #1023796
Posted Friday, November 19, 2010 2:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 18, 2010 4:51 AM
Points: 3, 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...
Post #1023819
Posted Monday, October 22, 2012 7:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
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
Post #1375426
Posted Tuesday, October 23, 2012 7:50 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 19, 2014 2:46 AM
Points: 2,879, Visits: 3,229
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 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1376053
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse