Solved

How to upgrade SSRS 2000 reports to 2005?

Posted on 2008-06-20
9
256 Views
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?
0
Comment
Question by:gtrapp
  • 7
  • 2
9 Comments
 

Author Comment

by:gtrapp
Comment Utility
Would I need visual studio 2005 "standard edition" or the "professional edition" to have the Report Designer?
0
 
LVL 4

Expert Comment

by:zx10r
Comment Utility
You don't need any version of Visual Studio, BI Studio comes with the installation of SQL Server 2005
0
 

Author Comment

by:gtrapp
Comment Utility
And BI Studio can upgrade my old .rdl files?
0
 

Author Comment

by:gtrapp
Comment Utility
How do I get to the BI studio? I thought I did a full install of SQL 2005
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:gtrapp
Comment Utility
I am reading many articles about how BI from the SQL 2005 install does not work or show up:

http://weblogs.asp.net/kdente/archive/2007/03/07/the-case-of-the-missing-business-intelligence-studio.aspx
0
 
LVL 4

Accepted Solution

by:
zx10r earned 250 total points
Comment Utility
this article has more info on upgrading http://technet.microsoft.com/en-us/library/ms143747.aspx

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

Author Comment

by:gtrapp
Comment Utility
Its not there and I did select it from the install.
0
 

Author Comment

by:gtrapp
Comment Utility
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?
0
 

Author Comment

by:gtrapp
Comment Utility
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
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
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.

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now