Enabling Filter depanding Static Selection[closed]

[Srik]

Hi ,

Do any one know how to acheive this conditional prompt.

Static filter:  Contract or Permement
when contracting provider selected contract ids need to be displayed in dropdown and should pass to report,  same way to for permenent.

contract id = contract.contract_id
permenent id =  employe.employeeid.


thanks for your suggestions. fileter is applied on application instead of cognos.

thanks once again.

[mrcool]

Hi....Can u b more clear...

[bdybldr]

I believe you're referring to cascading prompts.  I don't think cascading prompts are possible unless the prompt is data-driven.  In other words, there must be a field in a database table that contains either "Permanant"  or "Contract" values.  That's how the dependent prompt knows what to display based on the parent prompt.

[shank]

I believe bdybldr is right. I would suggest you use a reprompt button and a conditional variable for the second prompt. conditionally display them according to the first selection.

hope that helps

Regards

Cognos Pal