BAQ Parameter Radio Buttons Include ALL as option

,

I want to create a parameter to select product types using radio button set, but I want to include ALL as a way to show all product types in lieu of selecting one. So I would have ALL, P1, P2, P3 as the options. I created a calculated field with Case statement that says if NOT ALL selected, then Product Type = selected. How do I code for when the user selects ALL?

I add an “OR” filter expression and add the selection where ALL was selected. Remember to put parenthesis around each full OR statement for clarity or changes that come later.

I see you’re doing this in a calculated field, so use the SubQuery selection tab.

Why not a list? If nothing is selected then you can use the skip condition if empty feature to return all

2 Likes

Ken, that was an awesome solution. I wasn’t sure how that skip worked. As usual, I was trying to do it the hard way when the easy way was right there in front of me. Thanks!!