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

Question

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

Stephen Schleyer 60

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?

Anonymous

2023-12-04T01:34:22.4266667+00:00

Hi @Stephen Schleyer

Did the answer help you? If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Accepted answer

0 additional answers

Your answer

Anonymous

2023-12-04T01:34:22.4266667+00:00

Hi @Stephen Schleyer

Did the answer help you? If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Answer 1

Anonymous

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

Stephen Schleyer 60 Reputation points

2023-11-28T21:20:45.95+00:00

This was my work-around from the problem I was having a couple of weeks ago with the Sub-Cat parameter not working with one of the dataset queries and working with the other. I added the code "and ((@SubCat IS NULL) or ITEM_SUB_CAT = (@SubCat))" to the queries and the application was ok with that. When the user wants to include all the Sub-Cat options, they leave the Null box checked otherwise they can input a Sub-Cat option. Since the users do not know what Null means I just wanted to change the label from "NULL" to "All".
Anonymous

2023-11-29T02:00:40.2933333+00:00

Hi @Stephen Schleyer

Then maybe what you want to implement is the other way of adding the "All" option mentioned in my answer. You can refer to that link.

I did a simple test. First add the "All" option to the query for the parameter "Name".

Then add 'All' in (@Name) in the main query.

Then set the available parameter values as usual. You can add the value "All" to the default value.

Preview:

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
Stephen Schleyer 60 Reputation points

2023-11-29T18:57:08.7833333+00:00

Your solution is similar to mine in that I am using the Null flag to include all Sub-Cat values and you were adding an 'All' value to the data. I prefer my method since I would not be adding bogus entries into the production table and our Sub-Cat value is only 2 characters anyway. I just wanted to know if it was possible to change the Null label in the parameter box to another value (in my case 'ALL').
Anonymous

2023-11-30T08:06:13.57+00:00

Hi @Stephen Schleyer

Can you show some screenshots to show the effect you want to achieve?

Best regards,

Aniya
Stephen Schleyer 60 Reputation points

2023-11-30T16:54:28.99+00:00

I just want to change the literal 'NULL' to 'All'. I want to keep the checkbox and to be able to use the Null value in the queries.
Anonymous

2023-12-01T01:13:11.42+00:00

Hi @Stephen Schleyer

If it's this checkbox, I already stated it in the previous answer. This is by design. It cannot be changed from "NULL" to "All".

Best regards,

Aniya

Share via

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

0 additional answers

Your answer