Hiding columns through conditional style HELP!

[fkli222]

I created a conditional style and applied it to columns on my report that I want to hide when I select from my parameter Summary or Detail view.

When I select 'Summary' it will hide certain columns (yellow) in between but I want the data to roll up instead of showing multiple lines. You can see in the screenshot below that the top is how it is currently showing after hiding the yellow. The Proposed underneath is how it should show after hiding.

Any thoughts would be greatly appreciated!

[BigChris]

I would create two lists and put them in a conditional block

[hespora]

Hi,


can either do what BigChris said, which is pretty much the easiest solution if you have only one selection of "include detail or don't include detail".

If you have multiple such selections, it gets a little bit trickier. Basically, what you have to do is to make sure that every data item you hide also has the same value across all rows, which you can either do with if..then..else on the parameters, or with prompt macros.

If you want to get real fancy, you may want to take a look at the technique presented here: http://cognospaul.com/2014/09/14/prompting-fields-list/