Dynamic Reports via SSRS Web Services

We want to embed reporting capabilities into a web application where the
user can select the columns they want in a report and build a where clause
on thier own. What is the best way to handle this with SSRS?

I was thinking we would handle building the sql stmts in C# and then we
would fill a strongly typed dataset and set it as a the datasource for a
rpt. I have not been able to find any sample code on how to dynamically
build a report with SSRS given a dataset. Is this possible? Am I even taking
the right approach for this problem?

Bruce
Tue Jul 22 08:04:27 CDT 2008

There are two way to do this. One is to use the built in support for user
definted reports. It is called Report Builder. It is getting a facelift in
RS 2008 and if you are just starting into using RS you might want to check
that out. Otherwise, look at it in RS 2005. I haven't used it but
essentially you build a report model that the user then uses to create their
own reports.

Otherwise, if you don't want to use this then you would have to create your
own RDL (report definition language). It is non-trivial but possible. I know
of people who have done this.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Dan" <dantheriver@hotmail.com> wrote in message
news:OF8N0a76IHA.4548@TK2MSFTNGP06.phx.gbl...
> We want to embed reporting capabilities into a web application where the
> user can select the columns they want in a report and build a where clause
> on thier own. What is the best way to handle this with SSRS?
>
> I was thinking we would handle building the sql stmts in C# and then we
> would fill a strongly typed dataset and set it as a the datasource for a
> rpt. I have not been able to find any sample code on how to dynamically
> build a report with SSRS given a dataset. Is this possible? Am I even
> taking the right approach for this problem?
>