HOW TO USE SQL 2000 REPORTING SERVICE IN ASP.NET 3.5

Search: Find

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles

Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Creating an SSL Certificate to ensure your confidential reports remain confidential

SQL Reporting Services - Answers to your questions

Notify me of new comments

Author

Thread: HOW TO USE SQL 2000 REPORTING SERVICE IN ASP.NET 3.5

vishwa

HOW TO USE SQL 2000 REPORTING SERVICE IN ASP.NET 3.5
Posted: Tuesday, July 13, 2010 7:02 AM (GST)

Hi all,

We have client who is using SQL 2000 for long period and they dont want to upgrade tp 2005/2008, they have requested certain reports to be developed using reporting services (2000), we are using VS 2005 for the development

My prime question is,

1. Does VS 2005 (asp.net & C#) support the SQL 2000 reporting services?

2. If yes then how to solve the problem with Report viewer component which is not a part of 2000 RS.

If any body has sample code to share please share the same, since I searched through Google I didn't get any solution

Pls help.

Thanks & Regards

Vishwanath.G

Comments:

Author Thread:

cnicho

HOW TO USE SQL 2000 REPORTING SERVICE IN ASP.NET 3.5
Posted: Tuesday, July 13, 2010 9:39 AM (GST)

Hi

We too have clients using SSRS 2000. We have delivered our application developed in VB.Net using VS 2008 (Win forms). We did this successfully using URL access to present reports and the SQL 2000 ReportServer web service to get the report list. We don't use the report viewer component.

HTH

Craig

William Vaughn

HOW TO USE SQL 2000 REPORTING SERVICE IN ASP.NET 3.5
Posted: Wednesday, July 21, 2010 5:56 PM (GST)

The problem is that each version of Reporting Services uses a different version of RDL. There are at least four versions at this point. Each version requires a matched report processor either hosted on the server or in the BI report tools--and in the Report Viewer control. There is no Report Viewer control that knows how to process RS 2000 (2003) RDL. By not upgrading you customer is not going to be able to take advantage of the new features and copious bug fixes installed in later versions.