COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: curious on 07 Apr 2013 09:14:22 AM

Title: add static choice to data pull down list
Post by: curious on 07 Apr 2013 09:14:22 AM
In my active report I have a  "data drop down list" . Is it possible to add a static choise as in a "normal" pull down list ?
I would like to add something like "most recent" or "all"

Title: Re: add static choice to data pull down list
Post by: sureshsugu on 08 Apr 2013 06:51:19 AM
Hi,
     Create 2 query and union.one for All and one for your actual data item. after union you can drag that data item to Active Report Object.

thanks,
Suresh.
Title: Re: add static choice to data pull down list
Post by: curious on 17 Apr 2013 06:31:49 AM
Thank you for your answer

When I use your suggestion, in a normal report I would add an extra condition in my query. Something like : when selected xxxx = 'Most recent' then maximum(date for report) else xxxx.

But how do i have to do this in an active report.
And how do i have to this when I use a data-dropdown-list ?