Showing the prompt values in a report based on security
This recipe combines the techniques learned in prior recipes to achieve a business requirement. Let's say that a report shows sales data by country and product line. Users can choose to see data for one or more countries.
However, we need to implement a security mechanism so that a user can choose only those countries to which they are supposed to have access. This is determined by the user group he/she belongs to.
Getting ready
Create a simple list report with Country, City, Product line, and sales Quantity as columns.
How to do it...
In this recipe, we will start by adding a filter for countries as follows:
Go to Query Explorer and insert a new detail filter and ensure that this filter is mandatory. Define it as:
[Country] in ?Countries?
Now add a new prompt page. Drag a value prompt onto it.
Follow the prompt wizard to set the following:
Link it to an existing parameter called Countries.
Create a new query for this prompt and call it Countries...
