Button for removing zeros for column

[je9]

Hi. In SAS VA Report Designer, is it possible to create a button with the function of removing all zeros for a given column?

I know it is possible to use a display rule to set the text color to be the same as the background color but is it possible to have a button on the report that would activate this display rule?

More specifically, is there a way to have a button the user can click to make all zeros in the middle column below disappear.

[SASKiwi]

As far as I'm aware there is no way to switch display rules on and off. They are created and assigned in Report Designer. The best I can think of is having two versions of the same report, one with zeroes displayed and one without.

[FredrikE · Accepted solution]

Hi!

I should be possible.

The easiest if you add a tab containers with tabs and then add two tables, one in each tab. in the first one you show everything and in the second you hide the 0 using a display rule.

Another way thou a bit more complicated would be to first create a custom dimension with two values, "show/hide". This can be done by using an existing dimension as input and create two groups.

Then add a button bar with dimension as category.

Create a text parameter that you add to the button.

Then create a calculated measure that checks the value of the parameter and sets the value to . if value of parameter is "hide" and if value is "show" set the value of the original variable that you are using in the table in tour example.

Then create a display rule  that change color on values ".", the one you created in your calculated measure.

Maybe this can help you some what 🙂

//Fredrik 

[je9]

Hi,

Thanks for the response!

What do you mean by "dimension"? I am using SAS VA Designer v7.4. I am not entirely sure I have or have used dimensions.

- Jenine

[FredrikE]

Sorry if I confuse you, dimension is the same as category, better 🙂 ?

//Fredrik

[je9]

Thank you! Brilliant, it worked!