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.
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
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.
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
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
Sorry if I confuse you, dimension is the same as category, better 🙂 ?
//Fredrik
Thank you! Brilliant, it worked!
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.