same parameter for different prompts

[jahnavi]

Hi Guruss,

I am facing the issue like this . I have 2 prompts one is the value prompt which contains today.last week,last month these are all static choices  and the second is date range i.e., date prompt. The user should select either this or that. I am tried all the ways in cognos. but no luck. Kindly suggest?

Regards,
Jahnavi

[cognosjon]

Hi in your first static prompt add another option titled User defined date.

then create a filter in your query in the following format

if(?staticprompt?=1) then (what ever date period you want it to be)

else if (?staticprompt?=2) then (what ever date period you want it to be)

else if(?staticprompt?=3) then (what ever date period you want it to be)

else (date field you are using for your date range prompt in_range ?Dateprompt?)

Hope it helps

[jahnavi]

Thanks its working fine with conditional formatting...