How to upgrade SSRS 2000 reports to 2005?

Posted on 2008-06-20
Last Modified: 2010-03-19
I have .rld files for some old reports from SQL 2000. I developed these with MS Visual Studio 2003. I like to upgrade these to SSRS 2005. The problem is that I don't have MS Visual Studio 2005.

Other issues are that the reports I want them to work on is web server, where I have WSS 2.0. WSS 2.0 needs .Net 2.0, so I can't install MS Visual Studio 2003 because this needs .Net 2.0.  MS Visual Studio 2003 works with .Net 1.1 and not 2.0. MS Visual Studio 2005 works with 2.0.

Could these old reports be upgraded with SQL 2005? Do I really need to use MS Visual Studio 2005?
Question by:gtrapp
  • 7
  • 2

Author Comment

ID: 21833850
Would I need visual studio 2005 "standard edition" or the "professional edition" to have the Report Designer?

Expert Comment

ID: 21834019
You don't need any version of Visual Studio, BI Studio comes with the installation of SQL Server 2005

Author Comment

ID: 21834034
And BI Studio can upgrade my old .rdl files?
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.


Author Comment

ID: 21834062
How do I get to the BI studio? I thought I did a full install of SQL 2005

Author Comment

ID: 21834109
I am reading many articles about how BI from the SQL 2005 install does not work or show up:

Accepted Solution

zx10r earned 250 total points
ID: 21834111
this article has more info on upgrading

as far locating BI Studio it should be under Start > All Programs > SQL Server 2005 > SQL Server Business Intelligence Development Studio

Author Comment

ID: 21834133
Its not there and I did select it from the install.

Author Comment

ID: 21834377
I have BIDs installed now.

I am following along the directions and it says Report Designer. Where is this located? All I have are the .rdl files. Do I need to create a new project?

Author Comment

ID: 21834423
The directions say:

Report definitions can be upgraded to a new namespace when you open an .rdl in the SQL Server 2005 version of Report Designer. You are prompted whether to upgrade the report definition when you open the report. Once you upgrade the report definition, you cannot open it in previous versions of Report Designer.

But now sure where in BIDS is this Report Designer

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query 2 31
Update one table with results from another table in SQL 6 23
MS SQL Server select from Sub Table 14 23
SQL - Simple Pivot query 8 13
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question