Search results
Suggest a FeaturePDF


Parameters option can be used to create a new user defined parameter, edit values of existing parameters and delete parameters including query parameters that link to report parameters.

Open dataset parameters dialog

Select a data in the DATA panel to which you want to add, edit or delete parameters.

Dataset panel

Refer Create Data section and create a data in report designer.

Click on the above highlighted icon, the context menu will open with list of options.

Dataset panel

Then, click on the Parameters... option in the menu to open Parameters dialog.

Parameters dialog

When you add a query variable to parameterize a dataset using the @ symbol in the query when creating a dataset,

Define parameter in query

A Report Parameter will be created automatically and it will be listed in the parameters panel and dataset parameters dialog.

Report parameter

Open Parameters dialog, the available parameters in the query will be listed in the parameters dialog like below,

Report parameter

If you import a shared dataset into the report, the list of available parameters in the shared dataset will be listed in the parameters dialog. You can modify the values for the parameters within the report scope, it does not affect the actual query in the shared dataset.

Create parameter

  1. To create a new parameter, click on the ADD button. Add parameter

  2. Parameter Name: In the Parameter Name text box, provide the name for the parameter. The parameter name must be unique within the dataset.

  3. Value: In Value field, provide the value for the parameter. The Value of a parameter can be a static value or an expression, but it cannot refer to any report items or fields. Create parameter

    The parameters which you create here will act as a User Defined parameter in the report, neither creates a query parameter nor affects existing query parameter.

Edit parameter

Open Parameters dialog, the available parameters in the query will be listed in the parameters dialog like below,

Report parameter

You can edit the Value for parameter and click OK. By default, Value contains an expression that refers to a report parameter.

You cannot edit the Name of the existing query parameter in the dataset using parameters dialog.

Delete parameter

Click on the Delete icon in the right corner to remove the required parameters from the dataset.

Remove parameters

If you delete a parameter from the dataset, it will not be automatically removed from Report Parameter. You need to remove it manually if needed.

Reorder parameters

When executing a query or processing the report, the result will be retrieved from database based on the order of the parameter in the query.

The below snap depicts the parameter list before reordering the parameters.

Before reordering the parameter

To change the order of the dataset parameters after creating it, follow the below steps.

  1. Click and hold the icon in the left corner of Parameter Name field. Gripper icon to drag fields
  2. Then drag and move the dataset parameter field to higher or lower position in the list. Drag parameter field
  3. Drop the dataset parameter field in desired position. Drag action demo

The below snap depicts the parameter list after reordering the parameters.

After reorder action