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

How can restrict the choice in prompt?

Started by alex_, 14 Dec 2012 09:25:47 AM

Previous topic - Next topic

alex_

Hi,

I have a prompt, which can be filtered by the following values: A, R, G and NULL.
These values are coming from one column in database.

How can restrict the choice to: 'A' and 'R', and to hide 'G' and NULL.
Prompt must to show only: 'A' and 'R'

Thanks.

MFGF

Assuming your prompt values are being retrieved via a prompt query in the report, just go to that prompt query and add a detail filter with the expression

[your prompt data item] is not null

Cheers!

MF.
Meep!

alex_