In a SSRS 2005 report that has multiple datasets/tables. Is it
possible to only run or display a particular dataset based on a report
parameter?
I have been able to set the hidden property on the report element.
However it still executes both datasets. Is it possible to control
which dataset is run?
> In a SSRS 2005 report that has multiple datasets/tables. Is it
> possible to only run or display a particular dataset based on a report
> parameter?
Bruce L-C [MVP] - 31 Jul 2008 16:03 GMT
No it is not. The best you can do is to send a bogus value to the dataset
you don't want to run so that it returns 0 records. Keep in mind that
although Reporting Services creates a one to one mapping between query
parameters and report parameters you can change this to an expression. In
the dataset go click on ... go to the parameters tab. Create the expression
for one of your query parameters that causes it to return 0 records when you
are not displaying it. In this way at least it will execute quickly.

Signature
Bruce Loehle-Conger
MVP SQL Server Reporting Services
>I have been able to set the hidden property on the report element.
> However it still executes both datasets. Is it possible to control
[quoted text clipped - 3 lines]
>> possible to only run or display a particular dataset based on a report
>> parameter?