Converting Reports FROM SQL RS 2000 TO SSRS 2005

I have abt 30 reports currrently in SQL 2000. My data still resides in SQL SERVER 2000. However, I need to convert these reports to SSRS 2005.

I want to use the cool features like sorting, multi-value parameters from the RS 2005.

Can you pl advise how I shud go abt converting these reports from RS 2000 TO RS2005 .

Thanks.

Download these files to your hard drive, import them into a new project for RS 2005 and you should be done. YOu can then redeploy them to the new server. Be aware that this is a one-way transformation, once in SQL 2005 format, they cannot be deployed in SQL 2000.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Thanks Jen, I will try that. Also, do you recommend any books/websites, that have good info on RS 2005? Pl suggest .Thanks again.|||

Hi Jen/others,

I now have SSRS 2005 installed and am converting reports over to SSRS 2005. My question is DO I need to manaully convert Each and evry RDL within a project , to SSRS 2005. Or is there a simpler method for the conversion?

|||Hi,

just open the project that contains all the reports and they will be converted automagically. But if you ask, if you will have to do this step, you will.

Jens K. Suessmeyer.

http://www.sqlserver2005.de