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

add static choice to data pull down list

Started by curious, 07 Apr 2013 09:14:22 AM

Previous topic - Next topic

curious

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"


sureshsugu

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.

curious

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 ?