SQL Server Performance Forum – Threads Archive

Newbie Implementation

Hi all, I am the network admin for our small company and we just recently upgraded from SQL 7.0 to SQL 2000. I am trying to get a handle on what Reporting Services may be able to do. Will I be able to create and run reports with just the Reporting Services software or will I need to purchase additional software like Visual Studio and then learn how to program it? Thanks in advance for your help, Kevin

It depends on what are your needs.
I suggest to donwload Microsoft articles about Reporting Services and see if is usefull to you.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks for the reply Luis. I just want to know if Visual Studio or some other programming component is required to create and run Reporting Services reports. In other words do I need to buy and learn an additional product or can I just dig in with Reporting Services in order to do some basic reports. Thanks, Kevin

I think you don’t need aditional components, but check: http://www.microsoft.com/sql/reporting/default.asp
HTH Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Hi Kevin, according to my informations, to install the report server and the report manager, you need only reporting services, but for report desingning you will require Visual Studio. Akthar

quote:Originally posted by kbachelder Thanks for the reply Luis. I just want to know if Visual Studio or some other programming component is required to create and run Reporting Services reports. In other words do I need to buy and learn an additional product or can I just dig in with Reporting Services in order to do some basic reports. Thanks, Kevin

Kevin, You will need a server with SQL installed (SQLRS requires a SQL instance to store it’s 2 DBs on) and the server will need to be a web server also. Install RS on this server (client tools not required on this server).
On a developer machine having VS.NET installed, install the client components of RS.
You can develop until your hearts content on the development machine, and once you are satisfied with the result you simply deploy it to the Reporting Server. Note: For RS you do not require a license if installed on the same box as a licensed version of SQL Server. Licenses are not required for any client tools, as they require a licensed copy of VS.NET to be used (at present). Hope this assists, Tony

]]>