NULL checkbox in SSRS report?

Question

In SSRS report if I mention `Nullable` tag in `ReportParameter` then it automatically creates a checkbox with text `NULL`. So is there a way to make the checkbox by default checked?

Answer 1

In SSRS, when you define a report parameter with the Nullable tag, it will indeed create a checkbox with the text "NULL" in the parameter dropdown, allowing users to select or deselect it. However, by default, this checkbox will be unchecked, meaning the parameter value is not null.

If you want to make this checkbox checked by default locate the parameter for which you want to set the "NULL" checkbox as checked by default.

In the "Default Values" section for the parameter, click on the "Specify values" radio button.

Click the "Add" button to specify a default value.

In the "Value" field, enter null (without quotes). This will set the parameter to null by default, which will also check the "NULL" checkbox.

Click "OK" to save the default value and then deploy.

Now, when you run the report, the "NULL" checkbox will be checked by default, indicating that the parameter value is null. Users can still uncheck it if they want to specify a non-null value.

Hope this helps!!