Can SQL Server 2008 Reporting Services use a list of objects as a data source in an ASP.NET application
I am working on ASP.NET Web Application (3/5). In the application, we collect lists of classes from different data sources. I would like to create a report in SQL Server SSRS that displays a report from the contents of one of these lists without dragging and dropping the list into the database (it would actually be a bunch of rules violation if we did). We are currently using SQL Server 2005, but we are considering moving to 2008. Is that what I want to do, and if so how to do it?
source to share
Reporting Services offers something called a DataSet extension. You can use this to render a report from your custom data source. You don't need to load them back into the database. However, some editions of SQL, such as SQL Express Reporting Services, do not support dataset expansion.
source to share
You might want to use the ReportViewer control that ships with Visual Studio 2005 and Visual Studio 2008.
It can run in "local mode" which does not require a report server from the report server. You simply remove it from the VS toolbox into an ASPX form, then code it with any IEnumerable collection as a data source, and then provide it with a report definition file for local mode (RDLC).
The RDLC file is basically the same as the original RDL (Report Definition Language), but it misses a few things like the data source your application provides. The ReportViewer control contains a smaller version of the report engine, so at runtime it "connects" the RDLC that you provide to the dataset or bridging collection and does the rest.
For more information on this control, visit the following site: www.gotreportviewer.com
NTN
source to share