Resolved: Hide/Render page based on multi-select value prompt

[SGD]

Hi All,

I have 7 pages in my report which are actually 7 different systems. All these 7 systems are availble in multi select value prompt. User requirement is that he can select either one or multiple or all systems in multi select value prompt and based on selection report page(s) should get displayed.

I know I need to apply conditional formatting to acheive this task but there are total 7 diffrenet systems which requires lot of different combinations to be added.

Could please anyone suggest about easy and optimum way to implement the same? Also, do I need to use 'string' or 'boolean' variable?

Thanks in advance.

Your help is highly appreciated.

[pricter]

Check this topic promptpageprompt with multiple values

[SGD]

Hi pricter,

Thanks for your reply however I have already tried that solution but its not working as expected  :(

[pricter]

At which point does not work as as expected?

[SGD]

Hi pricter,

As I mentioned in my original post, there are 7 different Systems. Thses 7 systems are displayed in multi-select value prompt. User can select either 1 or multiple or all systems and run the report.

Respective single page gets displayed properly when User selects single system in multi-select value prompt but it does not show respective multiple pages when User selects multiple systems in multi-value prompt.

Below are my system names which are populating directly from database table:

AoA
HBD
HWD
CWD
DED
WILD
BAM
WADE

Please suggest.

[pricter]

Which is the expression that you use in variable?

If you add a layout expression to a page (Paramvalue('yourprameter) and select multiple values on the report what does appear?

[SGD]

Single selected value: AoA

Multi selected value: AoA, HBD, WILD, BAM

All selected value: AoA, HBD, HWD, CWD, DED, WILD, BAM, WADE

I am using expression as below for string conditional variable:

ParamValue('p_system')

[pricter]

Instead of using a string variable create seven boolean variable one for each system

For example  use the following expression
for AoA
ParamDisplayValue('p_system') contains 'AoA'
for HBD
ParamDisplayValue('p_system') contains 'HBD'

and so on

[SGD]

Thanks pricter... :)

your solutions worked...!!!