Reporting Services in SQL 2000

I would like to learn/more, practice creating and using reports but I don't know if I can do that on my home laptop with version 2000. I know, I know... upgrade to 2005. Can't do that due to technical difficulties on my other pc. Can I do this with my current setup?

thx

Kat

Yes you can. For SQL 2000, Reporting Services came as an add on component rather that being part of main install package.

You will need to have Windows 2000 or XP Professional which comes with IIS. This is required for running Reporting Services.

|||

here are some links that will be helpful to you:

Download of Reporting Services for SQL Server 2000
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en

Reporting Services for SQL Server 2000 documentation
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e550d73-8f35-435e-bb71-c8573a1cdbdb&DisplayLang=en

White papers and Technical articles about Reporting Services for SQL Server 2000
http://www.microsoft.com/technet/prodtechnol/sql/2000/technologies/rptsvcs.mspx

hope this helps,

Tai Yee
SQL Server

|||

It looks like I can't do this on a standalone pc, but need to have a server that I'm using... frustrating!

Kat

|||

Hi,

Do you have the SQL Server 2000 is installed on your computer? As I remember, Reporting Services needs at least a Standart Edition for SQL2K

If you have SQL Server, then you need the IIS also installed on your pc.

If you want to create reports, you need also the VS.Net 2003 installed on your pc.

I can all run them on my laptop which is an XP SP2. Your machine does not need to be a server :)

Eralper

http://www.kodyaz.com

|||That's right. But I believe you need XP Professional and not XP Home edition because you don't get IIS with XP Home.|||

I only have 2000 Professional Edition. Looks like I'll have to wait for my other laptop to be repaired and then I'll try again.

I HOPE, I HOPE, I HOPE it works!

thx

Kat

|||Windows 2000 Professional should work just fine.|||

Hi,

I should get my xp professional laptop back this next week and I will have the Developer edition of SQL Server 2000 soon to be upgraded to 2005. You say I need IIS installed which I understand, but is VS.Net 2003 a free product or does this have to be paid for?

thx,

Kathleen

Reporting services In ASP.NET

Hi All!

I'm starter of Reporting services in asp.net. please let me know some Address to learn it. Thanks

Hi duynnh,

Theres a series of videos on SQL Serverhere on asp.net. Numbers 10 and 11 cover reporting.

After that check out theReporting Services section on msdn.

I hope that helps.

|||

Hi,

Check these links

http://www.ondotnet.com/pub/a/dotnet/2004/11/29/sqlreporting.html

http://aspnet.4guysfromrolla.com/articles/031605-1.aspx

http://www.123aspx.com/Directory.aspx?dir=349

http://www.c-sharpcorner.com/UploadFile/chauhan_sonu57/SQLReportingServices03032006002905AM/SQLReportingServices.aspx

http://codebetter.com/blogs/peter.van.ooijen/archive/2005/11/15/Using-SQL-reporting-services-in-an-asp.net-application-with-some-notes-on-report-parameters.aspx

http://www.dotnetheaven.com/UploadFile/ursbgiri/106012007065515AM/1.aspx

Hope these links may be helpful..

|||

Hi All!

Thanks for your support. Can you give me some example about: ASP.NET 2.0(C#), Report viewer, Reporting Services. Please help me. Thanks

|||

You can check this site it will be great help

http://www.gotreportviewer.com/

|||

You can try these...

http://www.c-sharpcorner.com/UploadFile/chauhan_sonu57/SQLReportingServices03032006002905AM/SQLReportingServices.aspx?ArticleID=1c048538-0c38-40dd-804e-2604e7dd5fa0

http://support.microsoft.com/kb/875447

|||

Try to look at these:

About ReportViewer Control in ASP.NET 2.0 (C#)

http://www.codeproject.com/aspnet/ReportViewer.asp

http://msdn2.microsoft.com/en-us/library/ms251712(VS.80).aspx

http://www.gotreportviewer.com/

Video Tutorial

http://www.ddj.com/database/199701924

hope it helps!