Stored Procedures
When you use a stored procedure to supply the dashboard with data, you should specify the stored procedure parameters. To do this, in the Dashboard Data Source Wizard dialog, select the stored procedure, and click Next.
On the next page, configure the parameters.
The following parameter settings are available:
- Name
- Displays the parameter’s name.
- Type
- Specifies the parameter’s type.
- Value
Specifies the parameter’s value. If the parameter type is set to Expression, you can invoke the Expression Editor dialog to specify the expression. For example, you can select an existing dashboard parameter to pass to the stored procedure.
For more information on how to specify the parameter value, refer to the following section: Provide the Query Parameter Value.
Click Finish to complete query modifications.
Note
If you bind a DashboardSqlDataSource component to a stored procedure that returns multiple data tables, the Dashboard Control uses only the first table.