Back to Devexpress

Stored Procedures

dashboard-117194-web-dashboard-create-dashboards-on-the-web-providing-data-working-with-sql-data-sources-stored-procedures.md

latest1.6 KB
Original Source

Stored Procedures

  • Nov 08, 2022

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:

NameDisplays the parameter’s name.TypeSpecifies 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.