COGNOiSe.com - The IBM Cognos Community

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.

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.

Thanks,
of course.  :)  ;D