This procedure requires a Metadata data source type. Establish this
data source and a query before continuing with the instructions below.
You can add dynamic interactivity to a published report such that when a user
executes or views it, he can specify how to constrain certain parts of the query
data. This is called parameterization. Follow the procedure below to
parameterize a Metadata-based report.
-
Open the report you want to parameterize.
-
Right-click the Parameters item in the Data pane, then select Add
Parameter... from the context menu.
The Add Parameter dialogue will appear.
-
Select or change the options according to the definitions specified in Simple SQL Output Parameterization.
-
Edit your query and add the columns you want to parameterize to the Conditions field.
-
Create a parameter token in the Value field of each row in the Conditions area, and a valid default value in the Default field.
Parameter tokens are in {braces} and do not contain spaces.
-
Click OK to save the query.
-
Include the parameterized fields in your report by dragging them onto the canvas.
-
Publish or preview the report.
When a user runs this report, he will be presented with an interactive field
that specifies an adjustable constraint for the column or columns you specified.