COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Srik on 09 Jul 2006 05:57:03 PM

Title: Enabling Filter depanding Static Selection[closed]
Post by: Srik on 09 Jul 2006 05:57:03 PM
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.


Title: Re: Enabling Filter depanding Static Selection.
Post by: mrcool on 10 Jul 2006 06:27:40 AM
Hi....Can u b more clear...

Title: Re: Enabling Filter depanding Static Selection.
Post by: bdybldr on 11 Jul 2006 12:42:45 PM
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.
Title: Re: Enabling Filter depanding Static Selection.
Post by: shank on 21 Jul 2006 11:35:36 AM
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