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

Multiple contains parameter in an optional prompt value

Started by YazidKurdi, 11 Nov 2020 01:55:40 PM

Previous topic - Next topic

YazidKurdi

Hello

I am building a report that contains three optional prompt values with a contains function, example:

([Data Item1]) contains (?paramter1?)

or

([Data Item2]) contains (?parameter2?)

or

([Data Item3]) contains (?parameter3?)

However, when a user enters one value only and leaves the remaining 2 parameters blank, the filter runs as such, example:
User filtered for [Data Item1] = 'xxx' and remaining 2 are blank

([Data Item1]) contains ('xxx')

or

([Data Item2]) contains ('')

or

([Data Item3]) contains ('')

Resulting in all rows being retrieved, I am assuming that when contains = "" , it retrieves all rows.
The required result is only the field the user enters.

Thanks