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.
Check this topic promptpageprompt with multiple values (http://www.cognoise.com/community/index.php?topic=17874.0)
Hi pricter,
Thanks for your reply however I have already tried that solution but its not working as expected :(
At which point does not work as as expected?
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.
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?
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:
QuoteParamValue('p_system')
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
Thanks pricter... :)
your solutions worked...!!!