Groups | Blog | Home
all groups > sql server reporting services > february 2006 >

sql server reporting services : VS 2005 Ate My Report!


CGW
2/6/2006 3:45:27 PM
Excited over VS 2005, I used it to create a new report project, shared data
source, and report. However, when I tried to deploy to a machine with SQL
2000 and Report server, the report emptied... as in all the structure. Now I
have nothing.

Am I right in assuming that only report projects created with VS 2003 will
run under SQL 2000 and reporting services? Because I have several servers and
not all have SQL 2005, nor will they be likely to have it anytime soon.
--
Thanks,

Jéjé
2/6/2006 7:44:56 PM
RS2000 (client) runs under VS2003 (extra price)
RS2005 (client) runs under VS2005 (included, no extra price)

RS2000 reports can be deployed and rendered with both RS2000 & 2005 servers.

an RS2000 report edited with RS2005 + VS2005 is converted and cannot be
edited with RS2000 + VS2003 anymore

RS2005 reports cannot be rendered by RS2000 servers.


[quoted text, click to view]

CGW
2/7/2006 5:37:25 AM
There should be no danger to our reports if the web app solutions themselves
are upgraded for use with VS 2005, right? As long as we don't open our report
projects with it?
--
Thanks,

CGW


[quoted text, click to view]
Bruce L-C [MVP]
2/7/2006 8:58:45 AM
RS is a framework 1.1 asp.net application. You need to leave that part of
the website using the 1.1 framework.

However you are integrating your web app should continue to work (whether
URL integration or web services). However, if you use the new control that
comes with VS 2005 it requires RS 2005 on the server end.

Note that you can have RS 2005 use SQL Server 2000 as its metadata store.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button