Search results

Define query parameters

In query designer, the query parameter can be created in both design and query mode. The following sections describes the steps to create query parameters in design and query mode.

Refer Create Data section for better understanding with the following sections. The below image showcases the initial view of query designer.

Query joiner icon in enabled state

Create query parameter in design mode

  1. Drag and drop a table into design area and open the Query Filters dialog, in the query designer. Open query filter dialog

    Refer Query filters section to learn more about query filters.

  2. Click on the Add icon, to create a new filter.
  3. Choose any dataset field in the first drop-down list.
  4. Choose any Operator in the second drop-down list.
  5. In the Value field, provide a value to filter the data.
  6. Select the checkbox next to the value filed, to create a new query parameter.
  7. Click on the OK button. Query joiner icon in enabled state

Once you save the dataset, an equivalent report parameters will be created under the PARAMETERS panel like below. Query joiner icon in enabled state

Create query parameter in code mode

  1. Click on the switcher in query designer toolbar, to switch to the query mode. Query joiner icon in enabled state
  2. Specify the query in the text area, the query specified in the below snap returns the list of data from the AdventureWorks database, SalesOrderDetail table for the Sales schema. Query joiner icon in enabled state
  3. Now, add the following WHERE clause at the end of the query to create a query parameter.

    WHERE  (([Sales].[SalesOrderDetail].[SalesOrderID] = @SalesOrderID))

    Query joiner icon in enabled state

  4. Click on the Finish button, now the Parameters dialog opens. Query joiner icon in enabled state
  5. Enter the value for parameter in the value field and click OK. Query joiner icon in enabled state

Once you save the dataset, an equivalent report parameters will be created under the PARAMETERS panel like below. Query joiner icon in enabled state