Passing Parameter Values
In this topic, you will learn how to pass parameter values to a dashboard.
SQL Queries
Filtering
Conditional Formatting
Calculated Fields Window Calculations
SQL Queries
The Dashboard Designer provides the capability to use a dashboard parameter as an SQL query/stored procedure parameter. To pass a dashboard parameter to an SQL query/stored procedure in the Data Source wizard or Query Editor, do the following.
Create a query parameter or select the required stored procedure parameter.
If necessary, you can select Expression editor... and specify an expression to bind a query parameter to a dashboard parameter using custom logic.
Filtering
You can filter the specified query of the SQL Data Source or apply filtering to a specific dashboard item according to the current parameter value(s) using the Filter Editor.
In the Filter Editor, you can compare a field value with the following objects.
A static value (represented by the 
icon). Click this button to switch to the next item mode ("another field value"), to compare the field value with another field value.
Another field value (represented by the 
icon). Click this button to switch to the next item mode (“parameter value”), to compare the field value with a parameter value.
A parameter value (represented by the 
icon). Click this button to switch back to the initial mode ("static value"), to compare the field value with a static value.
Thus, to compare a field value with a parameter value, click the 
button, then click the 
button.
Conditional Formatting
You can apply conditional formatting to a specific dashboard item according to the current parameter value when creating the Expression format condition. In the Expression dialog, you can compare a field value with parameter values in the same manner as in the Filter Editor dialog.
Calculated Fields
You can use parameters when constructing expressions for calculated fields. This allows you to dynamically evaluate values of the calculated field depending on the current parameter value.
To include the required parameter in the calculated field expression, click Parameters in the Expression Editor dialog and doubleclick the required parameter.
Window Calculations
You can use parameters when customizing expressions for window calculations. This allows you to apply a calculation dynamically, depending on the current parameter value.
