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