If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Date Prompt Issue

Started by imts, 07 Apr 2011 01:33:15 PM

Previous topic - Next topic

imts

Hi Cognos Gurus,

I need a OPTIONAL DATE RANGE prompt on the prompt page which looks something like this

Start Date
- <Earliest Date> Or <select a Date from the Picker>
End  Date
- <Latest Date> Or <select a Date from the Picker>

-----------------------------
Problem is ; I have to use the ?My_Date_Parameter? in my query with some IF conditions .

If I use it in DATA ITEM then the prompt becomes mandatory [And i lose the <Earliest Date> and <Latest Date? option in the prompt]

If I use it in filter section then I am not able to use the IF clause ; it gives error - I want something like this in filter

IF (?My_Date_Parameter? = '1-1-1900' ) then (1) else (2)

[just an example but it fails :(]

Please help .

-TS

PRIT AMRIT

QuoteIF (?My_Date_Parameter? = '1-1-1900' ) then (1) else (2)

'1-1-1900' -- Is your default selection? Looks like you are trying to filter the report dynamically e.g. current date or some other date field?

What exactly you want to write in the FILTER? Can you post your expression?

Thanks
prit