how to display reports based on user prompt

[asini]

Hello Greetings To All,

actually we have 3 same reports(except date condition is different)

1) is short term liquidity (has account no, name, amount) Condition--> Payment Date between today & nextyear same day
2) is long term liquidity(has account no, name, amount) Condition--> Payment Date greater than nextyear same day
3) is all liquidity(has account no, name, amount) Condition--> Payment Date greater than Today

these three reports working fine

but as per authorities they requested us to create only one report with prompt shows options as "Short Term" , "Long Term", "Both"
when the user selects option the report has to work

once again remind you, in all three reports all columns were same just the date column condition is different

Please Help Me

Really appreciate it, Thanks in advance

asini

 

[ict2000]

Try the following option:

1. First create the following query item (say Filter1):

CASE
WHEN (?Option? = 'Short Term' AND Payment Date between today & nextyear same day) THEN (1)
WHEN (?Option? = 'Long Term' AND Payment Date greater than nextyear same day) THEN (1)
WHEN (?Option? = 'Both' AND Payment Date greater than Today) THEN (1)
ELSE (0)
END

2. Then drag the above item to filters and set it to equal to 1 : [Filter1] = 1

Make sure you remove the old filter.

 

[asini]

Hello ICT,

First of all thank you veru much for your reply,

in step 1 you asked me to create a query item that is in Report itself right?

and also in step 1 you are using ?Option? where do i need to declare this ?option?

please give me your valuable sugestion.

could you please explain the procedure

Best Regards
asini

 

[ict2000]

Assume you are using Cognos 8. To reference a prompt, you need to put ? before and after the prompt name. So if your prompt is called for example param_option, then it will look like this: ?param_option?.

 

[blom0344]

A prompt is associated with a parameter and promptname is not relevant in this respect. The parameter name associated with the prompt can have any name , but it is the parameter that is used with leading and trailing '?', like:

?some_parameter?

Ties Blom