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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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?
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.


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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

691 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