I have a report that uses a token prompt to alter whcih dimension is displayed as the crosstab columns.
I need to have one dataset with zero/blank columns supressed and one dataset with no suppression.
Is there a way to change this based on a prompt/condition?
My current workaround is to create two different reports and drill between them when changing the column, but I'd rather keep it all in one report if possible.
Thanks.
I don't know of a way to change suppression options conditionally, but you could have two crosstabs in the layout, both referencing the same query, but one with suppression and one without. Then conditionally render only one or the other based on the prompt.