If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

show and hide prompts from the selection of another promt

Started by gurralakrishna, 05 Apr 2013 09:10:37 AM

Previous topic - Next topic

gurralakrishna

Hi All,

I have to develop two implementations in a single Cognos 8.1report like below

1)My report having ten fields.when i select the fields from the prompt it should be present in the report otherwise it should be hide from the report.
above implementation was achieved

2)In the same report  I have prompts for all fields.According to the first implementation what are the fields selected in the prompt ,the fileds having prompts should be display on the prompt page for prompting for the report other wise it shoild be hide like report fields.   

Could you please help me

Many thanks in advance

Regards,
Krishna.

RKMI

Hi Krishna,

Are you talking abt Paramdisplayvalue(PDV) expression? You can write an expression with the PDV then if you want it be show on prompt page it will show up when you do a reprompt or auto submit one of the prompts so they get displayed on selection.

Thanks,
RK

gurralakrishna

Thanks RK.

It is not PDV. I need to dispaly prompts in another prompt page for prompting , when i select the required report fields from  first prompt. 

Ex:My Report having A,B,C,D,E,F etc...

My firtst prompt page having the prompt for select reruiered report fields
In this case i was selected A,B,D, F from the first prompt.

Now in secod prompt page the fields A,B,D,F having prompts should be enable(display A,B,D,F prompts and hide prompts for C,E)

I was used conditional blocks for this,but in this case conditional blocks displaying only one prompt and i need to dispaly more than one prompt when i selectd from first prompt,

Many thanks in advance.

Regards,
Krishna.

RKMI

Hi Krishna,

You are on the rite track, you need to make mulitple conditional block unique to its own conditional variable. I know it becomes diffcult if its like 10-15 prompts but, there no easy way to translate that logic.

I would recommend if there are least optional prompts which are hardly used create one small section grouping and based it on one condition.

For example,

Prompt Page 1 you have A-F, and if DEF are the least freqently used then show them in prompt page 2 irrepective if they meet a condition or not.

Prompt Page 2 top section is a based on condition and whether the conditional variables are meet, then bottom section name it something section it of call it Optional with no conditional variable set.

I know this is not your requirment but if comes down to make 25-30 odd prompts you might want to start to draw a line with your user too. Especially if it done it like 20 odd reports or more...

Thanks,
RK

wyconian

Hi have you tried using render variables on the prompts?  You can create a varaible something like paramValue(?prompt_a?) is not null and have the results being Y or N.  On the next page you can render the prompt for column A to only display where the result of the render variable = Y.

You would have to do that for all the prompts/columns so not a quick solution