Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / July 2008

Tip: Looking for answers? Try searching our database.

Visual Studio 2008 and SRS 2000

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Matt Maggio - 23 Jul 2008 21:37 GMT
We have a SQL Server 2000 instance that is currently working properly.  We
have a developer who has been creating reports for this RS just fine.  I
would like to being to create my own simple reports.  Can I use Visual
Studio 2008 Standard to develop for RS 2000?  Will the version of VS work
properly with this version of SRS 2000, or is there a better tool for this.
Thanks for your help

Matt
Bruce L-C  [MVP] - 23 Jul 2008 22:01 GMT
You cannot use VS 2008 or VS 2005 for RS 2000 reports. You have to install a
version of VS 2003 (not sure how you do that now) It used to be that I told
people to buy VB.net 2003 (cost about $100). You would install this and then
the report designer. Starting with RS 2005 a version of VS is bundled in.
The way it works is a special version of VS is installed IF you do not have
the appropriate version of VS installed. If you do then it integrates with
the already installed VS. Here is how it pairs up:
RS 2000 - VS 2003 (must have a version of VS installed)
RS 2005 - VS 2005 (if no VS 2005 installed then it installs a special
version of VS just to host the report designer)
RS 2008 - VS 2008 (if no VS 2008 installed then it installs a special
version of VS just to host the report designer)

All three can be installed on the same machine (assuming you have disk
space).

If you can I strongly recommend updating to RS 2005. Note that RS 2005 can
use SQL 2000 for its data store BUT you do have to have a SQL 2005 license.

HTH,

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> We have a SQL Server 2000 instance that is currently working properly.  We
> have a developer who has been creating reports for this RS just fine.  I
[quoted text clipped - 4 lines]
>
> Matt
Matt Maggio - 23 Jul 2008 22:45 GMT
Thanks very much for the help Bruce!

Regards
Matt

> You cannot use VS 2008 or VS 2005 for RS 2000 reports. You have to install
> a version of VS 2003 (not sure how you do that now) It used to be that I
[quoted text clipped - 26 lines]
>>
>> Matt
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.