Dynamic Reports via SSRS Web Services

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 22 Jul 2008 05:52 GMT

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?

Reply to this Message

Bruce L-C [MVP] - 22 Jul 2008 14:04 GMT

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.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting 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
[quoted text clipped - 5 lines]
> build a report with SSRS given a dataset. Is this possible? Am I even
> taking the right approach for this problem?

Reply to this Message