The requested page is not available for the requested platform. You are viewing the content for Default platform.

Configure Query Parameters

  • 2 min to read
Note

The default Report Designer implementation uses the Data Source Wizard (Fullscreen) version. To use the popup version instead, disable the ReportDesignerWizardSettings.UseFullscreenWizard option.

This page is displayed if any custom queries and/or parameterized stored procedures were selected on the previous wizard page.

On this page, you can manage parameters that are used in queries and/or stored procedures and specify parameter values.

To add a new parameter, select a query and click the web-designer-report-wizard-button-query-add button.

web-designer-report-wizard-03-configure-parameters

To delete a parameter, click the web-designer-report-wizard-button-query-delete button.

To customize an existing parameter, click the web-designer-report-wizard-button-query-edit button.

Next, you can specify the parameter name, type and value.

web-designer-report-wizard-04-configure-parameters-expression

When the parameter type is set to Expression, the value editor displays the ellipsis button, and clicking on it invokes the Expression Editor.

web-designer-expression-editor

To link a query parameter to an existing report parameter, type the report parameter name using the following syntax: ?parameter1.

Click Next to proceed to the next wizard page: Configure Master-Detail Relationships.

Note

When invoking the SQL Data Source Wizard to edit an existing data source, another version of this page is displayed.

To learn how to switch the SQL Data Source Wizard to the single-query mode, see the following example online: End-User Report Designer - How to switch back to using the single-query Data Source Wizard version.