Its possible convert SSRS report developed from VS2008 to VS2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Its possible convert SSRS report developed...

Its possible convert SSRS report developed from VS2008 to VS2005

Rate Topic

Display Mode

Topic Options

Author

Message

giulianocardoso

Posted Monday, July 05, 2010 9:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 6:55 AM
Points: 7, Visits: 125

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

Andy Hogg

Posted Wednesday, July 07, 2010 10:18 AM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, February 23, 2013 11:11 AM
Points: 488, Visits: 810

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

giulianocardoso

Posted Wednesday, July 07, 2010 11:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 6:55 AM
Points: 7, Visits: 125

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

H4K

Posted Saturday, November 06, 2010 12:51 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127, Visits: 507

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

dbendixen

Posted Friday, November 19, 2010 8:19 AM

Forum 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

giulianocardoso

Posted Friday, November 19, 2010 1:33 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 6:55 AM
Points: 7, Visits: 125

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

manu.marathimanoos

Posted Friday, November 19, 2010 2:11 PM

Forum 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 Smile

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

H4K

Posted Monday, October 22, 2012 7:38 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127, Visits: 507

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

EdVassie

Posted Tuesday, October 23, 2012 7:50 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:46 AM
Points: 2,636, Visits: 2,788

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 4 June 2013: now over 24,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 »

Permissions