Query Parameters

A query parameter is created for each query variable or input parameter, and a report parameter is created for each query parameter.

Click on the Query Parameter icon in the query designer toolbar.

Query Parameter icon

Now the query parameters dialog will be launched.

Query parameters dialog

Adding Query Parameter

  1. Add a query parameter through clicking the Add icon in the dialog.

    Query parameters Add icon in the dialog

  2. Parameter Name : In the Parameter Name text box, type the name of the query parameter.

  3. Value : In Value field, type or select the value to pass to the parameter.

    • Values can contain an expression that evaluates to a value to pass to the query parameter. The expressions in the value list includes the field list for the current report.

      Query parameter values

    • To set expression click on the icon in the right side of the value field.

      Expression click

      Expression dialog

    • The icon will be indicated in Black color, if the expression is applied.

      Expression field applied

  4. Click OK to save the query parameters.

Remove Parameters

  • Click Close icon to remove the query parameter from the list.

    Remove parameters

Reorder item

To change the order of an item in the list, click and hold the icon in the left corner of Parameter Name field, and then drag the item to higher or lower position in the list.

Parameters drag

The position of dragged item is shown as below:

Parameters reorder