SSRS run SQL/DataSet conditionally
- by MikeTWebb
Hello....
I have an SSRS report that contains several subreports. The user has the ability to select/deselect which subreports they want to produce using several Boolean parameters. If a subreport is deselected then it is not rendered by setting the Visibility property. However, the DataSet associated with the de-selected subreport still executes causing the execution time to take longer than expected.
Is there any way to tell a dataset on a subreport or Tablix not to execute based on a Parameter selection?
Thanks