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

Exclude all when no value is selected

Started by mria.ina, 06 May 2015 08:14:55 AM

Previous topic - Next topic

mria.ina

Hi

I am facing the following request:
Prompt Page needs two boxes: Prompt A points to values from table A and Prompt B points to values from table B. The desired outcome is:

If values are entered for prompt A, apply filter. If not, exclude all results from table A
UNION
If values are entered for prompt B, apply filter. If not, exclude all results from table B

I have tried several appraches but nothing seems to work, can you please provide some help on the matter?

Thanks