Query Parameters inJavaScript ReportDesigner

11 May 20222 minutes to read

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.

JavaScript ReportDesigner param icon

Now the query parameters dialog will be launched.

JavaScript ReportDesigner param dialog

Adding Query Parameter

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

    JavaScript ReportDesigner param add

  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.

      JavaScript ReportDesigner param exp icon

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

      JavaScript ReportDesigner param exp menu

      JavaScript ReportDesigner param exp dialog

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

      JavaScript ReportDesigner exp black

  4. Click OK to save the query parameters.

Remove Parameters

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

    JavaScript ReportDesigner delete parameter

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.

JavaScript ReportDesigner param drag

The position of dragged item is shown as below:

JavaScript ReportDesigner param reorder