COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: chinnucognos on 25 Nov 2013 05:54:36 AM

Title: Date Prompts filter
Post by: chinnucognos on 25 Nov 2013 05:54:36 AM
HI All,


Let me explain my requirement,
i have three date prompts i.e 1.From Date
                                            2.To Date
                                            3. Assign Date.
Here Assign Date prompt range should be with in "From Date  & To Date Prompts".

For example: If From Date= 15-Aug-2012
                        To Date= 14-Feb-2013,
               then user has to select Assign Date(Date prompt) within above two dates

Note: All prompts are not multiselect.

Thanks in Advance...
Title: Re: Date Prompts filter
Post by: chinnucognos on 25 Nov 2013 06:27:24 AM
Any Clue...
Title: Re: Date Prompts filter
Post by: BigChris on 25 Nov 2013 06:39:07 AM
You could probably do something using the PromptAPI, although I haven't tried using that yet. Alternatively you could set up a render variable that only displayed information if the Assign Date is between FromDate and ToDate. My preference would probably be to just put a text box on the prompt page telling the user to select an Assign between the From and To dates...
Title: Re: Date Prompts filter
Post by: chinnucognos on 25 Nov 2013 07:03:14 AM
Can u be elaborate on render variable, i mean what conditon should i hav to give in variables.
or
If possible, Please give Javascript Prompt api for this( i tried to google it, but not getting right script)
.
.
.
.Thanks in advance