Stored Procedures

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Dashboards and Reports Customization Guide > Designing Dashboards > Provide Data > Working with SQL Data Sources 

Stored Procedures

If you use a stored procedure to supply the dashboard with data, you should specify the stored procedure parameters. In the Dashboard Data Source Wizard dialog, select the required stored procedure and click Next.

 

wddStoredProcedure

 

On the next page, you can configure the parameters.

 

wddstoredprocedure2

 

The following parameter settings are available.

 

Name - Displays a 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 required expression. For example, you can select an existing dashboard parameter to pass to the stored procedure.

 

Click Finish to complete query modifications.