DRAG DROP
You are designing a dataset for a SQL Server Reporting Services (SSRS) report.
The report includes the report items displayed in the following graphic.
The dataset is sourced from a commonly used stored procedure in an inventory data mart
hosted in a SQL Azure database.
It returns the status for all products across all storage sites. The report must display data for
the storage site that is selected by the Site report parameter. You cannot change the stored
procedure code.
You need to filter the dataset to use only data specific to the selected site.
How should you configure the filter?
To answer, drag the appropriate expression or expressions to the correct location or
locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Explanation:
Note:
To set a filter on the dataset
1. Open a report in Design view.
2. Right-click a dataset in the Report Data pane and then clickDataset Properties.
TheDataset Propertiesdialog box opens.
3. ClickFilters. This displays the current list of filter equations. By default, the list is
empty.
4. ClickAdd. A new blank filter equation appears.
5. InExpression, type or select the expression for the field to filter. To edit the
expression, click the expression (fx) button.
Box 1: Here we use the Fields expression.
6. From the drop-down box, select the data type that matches the type of data in the
expression you created in step 5.
7. In theOperatorbox, select the operator that you want the filter to use to compare the
values in theExpressionbox and theValuebox. The operator you choose determines the
number of values that are used from the next step.
Box 2: we test for equality.
8. In theValuebox, type the expression or value against which you want the filter to
evaluate the value inExpression.
Box 3: we compare to the value of the Parameter named Site.
9. Click OK.
Reference: How to: Add a Filter (Reporting Services)
ok