In SSRS, how can I change the NULL checkbox label for an input parameter

Stephen Schleyer 60 Reputation points
2023-11-27T15:03:24.15+00:00

I am creating an SSRS report in Visual Studio 2019.

Is there a way to change the “NULL” label to “All” for an input parameter checkbox?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,867 questions
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-11-28T01:52:14.35+00:00

    Hi @Stephen Schleyer

    Are you talking about the "NULL" checkbox in the picture below? This is by design. This checkbox will appear in the report preview when you select "Allow null value" in the parameter properties.

    User's image

    If you want to add the "all" option, then you can select "Allow multiple value" in the properties. When the parameter available value is "get values from a query", the "select all" option will appear in the parameter drop-down list of the report preview.

    User's image

    For another way to add the "all" option, you can refer to this blog: https://dataqueen.curiousmind.ca/2011/06/how-to-default-to-all-in-an-ssrs-multi-select-parameter/.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya


0 additional answers

Sort by: Most helpful