Reports in SSRS with additional parameters

Question

I can create reports with parameters in SQL reporting services and use them in C#(reportviewer), but now I have a problem. I have to create report with not only required parameters, but also with additional parameters - checkboxes(boolean). But this isnt the problem.

The problem is here: How to build reports, which use different stored procedures(datasets) according to values of additional checkboxes? It is possible do it in Reporting Services or it can be done later in C#?

Answer 1

You can build dynamic string queries in query expression window, for example:

=Iif(SomeParameter!Value = true, "query1", "query2")

But beware if you have many conditions and parameters as debugging gets more and more tedious.