You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance.
The report contains query parameters that allow users to filter the contents of the report. The
report queries the data source randomly.
You configure the report to be rendered from a report execution snapshot.
You need to ensure that users can continue to use parameters to filter the report.
What should you do?
A.
Add a default value to all parameters.
B.
Modify the datasets to use the Table query type.
C.
Remove the filters from the dataset queries. Use the parameters to filter the datasets.
D.
Move the queries to the stored procedures. Use the stored procedures to populate and
filter the
datasets of the report.