The boolean parameter allows for a true or false (yes/no) to be input by a report consumer via a checkbox control. In the example below, a parameter named "Is Anon Allowed" is shown to the user.
In addition to the to the common attributes available to all parameter types the following additional attributes are available:
- Is Value Required
- Defines whether a user must enter a field value before executing the report. Click here to read more about the "Is Value Required" attribute.
- Default Value
- Defines whether the checkbox shown to the user will be TRUE or FALSE by default
Usage in SQL Command Text
A single variable will be declared as a BIT in the auto-generated section and can be used as a standard SQL variable. In the below example a parameter with a programmatic name of "IsAnonAllowed" has been added to the report and is utilized within the SQL expression.
The generated SQL when executing a report containing a number parameter type is shown below:
