Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Configure Query Parameters

  • 2 minutes to read

On this wizard page, you can manage parameters that are used in queries and/or stored procedures selected on the previous wizard page, as well as specify parameter values.

#Specify Parameter Values

A parameter value can specified in one of the following ways.

  • Parameters can be assigned static values (according to the specified parameter type), which is illustrated in the following image.

    data-source-wizard-multi-query-configure-parameters-static-values-date-time

  • Alternatively, you can link a query or stored procedure parameter to a report parameter, whose value can be requested each time before the report document is to be previewed or exported. To do this, enable the Expression check box and select an existing report parameter of the corresponding type or create a new one.

    report-wizard-page-multi-query-parameters

  • Another option is to calculate a parameter value based on an expression. To do this, enable the Expression check box and run the Expression Editor.

    data-source-wizard-configure-query-parameters-expression-editor

#Manage Parameters

To delete a specific parameter, select it on this wizard page and click Remove.

To execute a specific query with the specified parameter values, click Preview and select a query.

data-source-wizard-configure-query-parameters-preview-drop-down-button

When previewing a query or stored procedure result, only 1000 first data rows are displayed. If a query contains a custom SQL, the entire result set is obtained.

To create a new query parameter, click Add and select a query.

data-source-wizard-configure-query-parameters-add-drop-down-button