conditional display static choice in cognos10.2

[gurralakrishna]

Hello All,
I have four prompts in my report and all prompts are having same static choices
ex: P1 having static choices are 1,2,3,4 and P2 having static choices are 1,2,3,4 and P3 having static choices are 1,2,3,4 and P4 having static choices are 1,2,3,4
when i run the report and select '1' in P1, it should not show in P2,P3 & P4
same as if i select '1' in P1 & '2' in P2 then both should not show in P3 & P4

Please help how to get this one?

Many thanks in advance

Thanks & Regards,
Krishna

[MFGF]

Hello All,
I have four prompts in my report and all prompts are having same static choices
ex: P1 having static choices are 1,2,3,4 and P2 having static choices are 1,2,3,4 and P3 having static choices are 1,2,3,4 and P4 having static choices are 1,2,3,4
when i run the report and select '1' in P1, it should not show in P2,P3 & P4
same as if i select '1' in P1 & '2' in P2 then both should not show in P3 & P4

Please help how to get this one?

Many thanks in advance

Thanks & Regards,
Krishna

Hi,

Static choices are, as the name suggests, static choices. Unlike dynamic choices which are driven by a query and can be filtered, static choices are predefined and static.

Do you have an option to get the choices in a table you can read? Alternatively, you could create "virtual SQL" in your report to drive values into queries for your prompts, eg

select * from (
values (
cast('ONE' as varchar(10))),
('TWO'),
('THREE'),
('FOUR')
)      
MFPromptContents (MFPromptValue)

Cheers!

MF.

[gurralakrishna]

Hi MF,

Thanks for your replay!

Can you please explain more

Thanks,
Krishna

[MFGF]

Hi MF,

Thanks for your replay!

Can you please explain more

Thanks,
Krishna

Sure. What do you need explained?

MF.