Impromptu 7 clever columns

[erwin123]

Hello,

I'm creating a crosstab and I want columns to be shown depending on the prompt.
I've created a prompt 'Shows report with Unitcodes (Y/N)?'.
I've created a calculation named Unit. It says something like 'if prompt = 'Y' then unitcode else NULL'.
Now the report does show me the unitcode if the prompt is Y and it won't show a unit if N. That's fine! The grouping is fine too!
But, here's my question. If I choose not to see the prompt the colunm is still shown on the report. The cells are empty but the column is still there!!!
Conditional formatting did not work. I can suppress a cell but not the whole colunm.
(I've tried to make it conditional HIDDEN but, the report still is showing the column.)
Is there a solution to this problem?

Off course I can create a new report but I prefer not to.

Thanks in advance,
Erwin.

 

[GilMerc]

Erwin123,

I want to do too and it doesn't works. Do you find a solution or you make a second report. Do you call a support of Cognos.

Gilles.

 

[erwin123]

Hello Gilles,

No, no solution for this problem yet. (For the moment I've build two reports but that's not what I wanted initialy)

I've contacted Cognos and they did could not offer a good solution neither. Still, I have the feeling there must be a way of solving this problem.

Is there anybody on this forum with a good idea????

Erwin.