I have a report that needs 3 parameters for filtering (Date, Period and Year). I want the user to just put in a date and then get Cognos to set the other 2 parameters automatically since every day belongs to a specific period and year. How can I do this?
Hi,
You can have a common parameter [single] for all 3 filters, using extract, to_char or to_date function you can modify the filter, like if its a year filter you can fetch the year from the parameter value and compare by saying like
Quote[Year]=extract(year,?year?)
, simillery you can do for remaining filters....
Thanks,
Gollapudi.
Thanks,
but that won't work in this case. The financial year goes from 1.May to 30.April, so for the 10th of December 2008 for instance the year is 2009 and the period is 08. I have a table for this, but I don't know how I can assign these values to my parameters ?Year? and ?Period? which I need for the filtering of the report. I need to show transactions on the selected date plus the Period to Date transactions for that period.
I tried cascading prompts, but all I get is the fields greyed out.