Display user prompt input dynamic

building reports webintelligence
1

Hello,
I’ve about 15 prompts for a single report. Only 4 out of 15 are mandatory. What I’m looking for is a way to print user prompt input summary so they can see what they selected during report run. Let’s say if you run the report providing 7 prompts value (4 mandatory and 3 optional) I only want to show 7 prompts in summary not the entire 15 prompts, and if you provide 5 prompts then only 5 in summary.
I’m using Webi (BO 4.2 SP4) and I can do it with built in summary function but that prints the entire prompt summary. All I need is what user provides in prompt window, but not the entire lists. Rarely, someone will enter the entire 15 prompts and that time all 15 need to show up.

Thanks,

zulu1900 (BOB member since 2005-07-27)

2

with UserResponse() you can print the values selected/entered
With IsPromptAnswered() you can identify whether the prompt is answered or not.

Combining these two write suppression logics to hide the parameters that were not answered.

anil.ganga1 :us: (BOB member since 2007-07-04)