Dashboard for Desktop > Dashboard Designer > Using Dashboard Parameters > Passing Parameter Values
In this topic, you will learn how to pass parameter values to a dashboard.
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.
•Enable the Expression checkbox for this parameter and select the required dashboard parameter in the Value column.
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. A parameter is inserted into the expression using the “Parameters.” prefix.
To see a list of available parameters, click Parameters in the Expression Editor dialog.
See Also
Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.
Send Feedback on this topic to DevExpress.