VS 2005/2008 rdlc-report with source of SQL 2000

  • Thread starter Thread starter Pieter
  • Start date Start date
P

Pieter

Hi,

We have to make a Windows Forms application, in VS.NET 2005 or preferably
2008, with local reports (*.rdlc, not *.rdl !!), which will be shown in a
Reportviewer in this application. So we won't install a Reporting Services
on our SQL Server.

The problem is: the source database is an SQL 2000. So the question is: will
it be possible to use an SQL 2000 as a datasource for our reports in VS.NET
2008? And if not with VS.NET 2008, will it work with VS.NET 2005?


Thanks a lot in advance,


Pieter
 
Hello Pieter,

Thank you for using Microsoft Managed Newsgroup Service, my name is Zhi-Xin
Ye, I will work with you on this issue.

Yes, in local mode, you can use the SQL Server 2000 as a data source for
the ReportViewer control in Visual Studio 2008.

However, in remote mode the ReportViewer control can only view reports
hosted on a SQL Server 2005 Report Server.

You can visit the following site for more information about the
ReportViewer control, it contains lots of FAQs.

http://www.gotreportviewer.com/

If you have any questions or concerns, please feel free to let me know.

Sincerely,
Zhi-Xin Ye
Microsoft Managed Newsgroup Support Team

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Indeed your question has nothing to do with Reporting Services. Yes, you can
use SQLServer2000 (or many others, such as Jet database, MySQL...for that
matter) as data source for you report, be it local report or reporting
services report with VS2005/8.
 
Back
Top