You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
There is a SQL Server 2008 Reporting Services (SSRS) instance. Now you are in charge of a report in this instance.
Query parameters are contained in this report which queries the data source at random. Users are allowed to filter the contents of the report according to the query parameters.
You perform this configuration on the report, making it be rendered from a report execution snapshot.
You must make sure that parameters can still be used to filter the report after the configuration.
So what action should you perform?
A.
A default value should be added to all parameters
B.
First, the queries should be moved to the stored procedures. Then populate and filter the datasets of the report by using the stored procedures.
C.
The datasets should be modified to use the Table query type
D.
First, from the dataset queries remove the filters. Then filter the datasets by using the parameters.