.Net integration with SQL Reporting Services

We are working on a project that includes the development of business classes
to contain all our data access routines. The goal is to be avoid writing
numerous sql statements (some quite complex and some duplicative) in SQL
Reporting Services, forms development etc..
We've tested this model in .Net 2005 using the Report Viewer control and
have a successful pilot. The data access class returns a data set(s) that we
use in the Report Viewer. We would like to move this model to use Reporting
Services.
The question is:
We will compile our data access classes into a dll. We would like to be
able to reference the data access class and return a data set(s) that can be
used by Reporting Services designer. So far we have not figured out how to
do this.
Any suggestions or tips? Thx,your starting point:
http://msdn2.microsoft.com/en-us/library/ms154655.aspx
also you'll found a sample data extension in the official SQL Server website
(part of the samples for SQL 2005)
"def59485" <def59485@.discussions.microsoft.com> wrote in message
news:C3079CEB-6497-46AC-8949-44975EA320A2@.microsoft.com...
> We are working on a project that includes the development of business
> classes
> to contain all our data access routines. The goal is to be avoid writing
> numerous sql statements (some quite complex and some duplicative) in SQL
> Reporting Services, forms development etc..
> We've tested this model in .Net 2005 using the Report Viewer control and
> have a successful pilot. The data access class returns a data set(s) that
> we
> use in the Report Viewer. We would like to move this model to use
> Reporting
> Services.
> The question is:
> We will compile our data access classes into a dll. We would like to be
> able to reference the data access class and return a data set(s) that can
> be
> used by Reporting Services designer. So far we have not figured out how
> to
> do this.
> Any suggestions or tips? Thx,