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

Filter on numeric data item

Started by kgcognos, 31 Mar 2016 01:57:22 PM

Previous topic - Next topic

kgcognos

For both filters below, the Condition is Show only the following specific values.
first filter is Customer Group (character field).
2nd filter is Year (numeric field).

When I run the report, The Customer Group filter is letting me select values from a list of customer groups.
But, Year filter is asking me to Enter a value then hit Insert to select instead of providing me valid years to select.
How can I set it up to show a list of years to select? 

I'm using framework manager Relational Package. 
 
Thank you in advance.

MFGF

Quote from: kgcognos on 31 Mar 2016 01:57:22 PM
For both filters below, the Condition is Show only the following specific values.
first filter is Customer Group (character field).
2nd filter is Year (numeric field).

When I run the report, The Customer Group filter is letting me select values from a list of customer groups.
But, Year filter is asking me to Enter a value then hit Insert to select instead of providing me valid years to select.
How can I set it up to show a list of years to select? 

I'm using framework manager Relational Package. 
 
Thank you in advance.

Hi,

In Framework Manager, you can specify the type of prompt you want an item to generate. Find the item, and in properties, expand the "Prompt Info" section. You will see a property called "Prompt Type" which will currently be set to Server Determined. Change the value of this property to Select Value, then re-publish your package.

Cheers!

MF.
Meep!

kgcognos

I changed the Prompt Type to Select Value but it is still not showing available years. Could it be a bug??
I tried with Select with Tree and now it is showing the years. Thanks so much this will make it easier for users.