How should you configure the filter?

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.)
Select and Place:


microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.