Can we use ado.net datasets to populate the reports
Using Datasets
Hot Topic
- Real Time ROLAP different then ROLAP
- How to format a text box to show bullets
- Change product key of SQL Server 2005
- Simple Question: Testing an Update Script
- SSMS Command line startup not connecting to object explorer
- SELECT WHERE
- Expression Problem - GrandTotal
- SSIS Deployment
- Conditionally adding a column to my custom component
- Can't Find NameColumn property collection
SQL Server
- Urgent help regd reducing the size and backing up of SQL Server Transaction log file
- ActiveX Script transformation column in SSIS but how???
- Errors in High Level Relational and OLAP Storage Engine
- Will package work on different CTP version?
- Chart Colours
- SSEM - How do you connect to an MDF file?
- programmatically set the paper size and and paper layout
- Using A/S 2005 in the DSV of an A/S 2005 solution
- DSO in SQL2005
- Service Broker in Express edition
Using Datasets
justinv
There are several options:
Do you know about the reportviewer winform and asp.net controls that report off ADO.NET DataTables
http://msdn2.microsoft.com/en-us/library/ms251671.aspx
If you want to add an ADO.NET dataset as a report data source, you would need to implement your own data processing extension. There's an example for a simple implementation documented here in "Using an ADO.NET DataSet as a Reporting Services Data Source" (published a couple of years ago, but you can still upgrade the code files in Visual Studio 2005 and compile and run this):
http://msdn.microsoft.com/data/archive/default.aspx pull=/library/en-us/dnsql2k/html/rsdsetex3.asp
To support a broader range of Reporting Services functionality, you need to understand the difference between a wrapper for a .NET data provider and a Reporting Services data processing extension. See if these links help:
http://msdn2.microsoft.com/en-us/library/ms159219(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms154655.aspx
--
Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.