- In the first row, in Name, type a name for the parameter.
- In Data type, select a data type for the parameter.
- In Direction, choose Input. This value means that the parameter is an input parameter.
- In Default value, type a default value.
The default value is passed to the WHERE clause of the query if there is no report parameter bound to this data set parameter. You must specify a default value and it must be a valid JavaScript expression. For example, if most reports display records with Active as a particular column's value, you can set the default value of the data set parameter to "Active". Enclose the default value in double quotation marks (" ") if you specified String or Date Time as the data type.
If you want the query to return all rows for a particular column when verifying the query results, specify "%" as the default value. For most SQL databases, % is a wildcard character that matches any sequence of characters. To specify "%" as the default value, you must meet two requirements:
- The corresponding clause in the query must use LIKE, which is a pattern matching option. For example:
- The data set parameter must be set to string type.