Hi
@Learner Cognos thank you for help. I have regular prompt page, with value prompts, where prompt value1 is Level1, second prompt2 is Level2... and those are cascading prompts, where prompts from Level2,3... are optional. So, I want if user does not choose nothing from prompt 2,3... to hide Level2,3.. from report.
I have also think to create separate crosstab for each Level, maybe that will be more functional?
------------------------------
Veljko
------------------------------
Original Message:
Sent: Thu September 05, 2019 05:57 AM
From: Learner Cognos
Subject: How to hide part of report when prompt is not choose
How about using a conditional block? It may affect the report performance if the crosstab contains a large amount of data though.
Can you show your prompts so that I can think of a better solution? :)
------------------------------
Luna
Original Message:
Sent: Thu September 05, 2019 05:16 AM
From: Veljko
Subject: How to hide part of report when prompt is not choose
Hi,
I have prompt page with several prompts from same hierarchy, levels. On the report page in crosstab I have inserted those hierarchy levels. Now I want to create, when user choose just first Level1 in prompts, to hide all others levels from report. If users choose all level prompts, then to show all those data on report.
How to succeed this. I have attached example of croostab with levels.
Thanks for help.
------------------------------
Veljko
------------------------------
#CognosAnalyticswithWatson