Print Page - Dynamic date prompts

Title: Dynamic date prompts
Post by: Chandrasekar on 06 Aug 2014 02:42:14 AM

Hi guru's,

I have two date prompts,
1st one is 'FromDate' prompt name - last year is default selection.
2nd one is 'ToDate' prompt name - current date is default selection, after the current date hidden to user selection view.

First one is i do well using javascript, Second one not get the solution.(current date only defaultly selected). I don't know how to hidden.

I am using 10.2 - Relational model.

Please share your knowledge.

Thanks & Regards,
Chandrasekar.

Title: Re: Dynamic date prompts
Post by: Chandrasekar on 06 Aug 2014 07:47:09 AM

Hi Guru's,

I am attached sample xml backup for your reference. Please help me.

Thanks & Regards,
Chandrasekar.

Title: Re: Dynamic date prompts
Post by: Chandrasekar on 16 Aug 2014 12:13:08 AM

Hi Guru's,

Please provide any solutions.

Thanks & Regards,
Chandrasekar.

Title: Re: Dynamic date prompts
Post by: karthik.kadambi on 16 Aug 2014 06:29:22 PM

You can do this without JavaScript techniques.

Call the parameter ?FromYear? and create a default selection '1900'

Create a filter in your main query

(?FromYear? = '1900' and [Year] = [Current Year])
or
([Year] between ?FromYear? and ?ToYear?)

[Current Year] = extract(year,sysdate())

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Chandrasekar on 06 Aug 2014 02:42:14 AM