Q:

Can SQL Server 2008 Reporting Services use a list of objects as a data source in a ASP.NET application

I am working on an ASP.NET (3/5) web application.  In the application, we assemble lists of classes from a variety of data sources.  I would like to create a report in SQL Server SSRS that renders a report from the contents of one of those lists, without pushing the list to the database (in fact, it would be a violation of a bunch of rules if we did that).  Right now we are using SQL Server 2005 but we are considering a move to 2008.  Is what I want to do possible and, if so, how do I do it?

A:

Reporting services offer something called as DataSet extensions. You may use that to render the report from your custom data source. You do not need to load them back into database. However, certain editions of SQL like SQL Express reporting services does not support dataset extension.

