Installing RS 2005 support for Visual Studio 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ryan - 31 Oct 2005 13:23 GMT

Hi All,

Does anyone know if it is possible to author RS 2005 reports using
Visual Studio 2003? I ask because I installed both SQL 2005 and Visual
Studio 2005 recently but support for designing or compiling reports in
VS 2003 has been removed by the installation.

My project in VS 2003 now falls over with an error stating that the
application for .rptproj files cannot be found, even though it all
works on a colleauges system and reports can also be designed in VS
2005.

Any clues? I can't upgrade to VS 2005 for some time due to the size of
the project and nearness of deadlines.

Thanks in advance

Ryan

Reply to this Message

Bruce L-C [MVP] - 31 Oct 2005 15:59 GMT

RS 2005 either installs its own development environment (which is a special
version of Visual Studio 2005) or it integrates with VS 2005. So, you can
install (side by side, it shouldn't mess with your VS 2003), no purchase of
VS 2005 is nessary. You cannot develop RS 2005 reports with VS 2003.

Just remove the RS projects from your solution and keep the non-report
projects together. If you are doing web services access to RS both RS 2000
and RS 2005 web services are supported.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hi All,
>
[quoted text clipped - 14 lines]
>
> Ryan

Reply to this Message

Ryan - 31 Oct 2005 19:33 GMT

Thanks Bruce, that is what I ended up doing anyway. Bit of a pain, but
only a couple of weeks until we upgrade fully anyway.

Do you know if the reports authored in 2005 can be deployed to a RS
2000 server with RS SP2? If not, I'll just upgrade our database anyway.

Thanks again

Ryan

Reply to this Message

Bruce L-C [MVP] - 31 Oct 2005 20:35 GMT

No, you cannot. RS 2005 reports have to deploy to a RS 2005 server. However,
the database can be 2000. This means that RS 2005 can use SQL Server 2000 as
its object/metadata store. You do need the 2005 SQL Server license however.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Thanks Bruce, that is what I ended up doing anyway. Bit of a pain, but
> only a couple of weeks until we upgrade fully anyway.
[quoted text clipped - 5 lines]
>
> Ryan

Reply to this Message