You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) solution that contains five sales dashboard reports.
Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met:
Users can manipulate the parameters for data analysis in a single trip to the data source. Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Filter data by using expressions.
B.
Specify the default values for each parameter.
C.
Create an available values list for each parameter.
D.
Create report parameters by using query parameters to filter data at the data source.
Explanation:
Tip: "automatically rendered" = "Filter expression" / "default"