Skip to Content
Former Member
Aug 08, 2017 at 08:09 PM

Crystal Reports:Is it possible to create a Multi value parameter that uses "AND" logic and not "OR"?

113 Views Last edit Aug 08, 2017 at 10:43 PM 2 rev

I'm fairly new to Crystal Reports. I have a report that uses a multi value parameter string to search through a block of text. A user pointed out that they would like the ability to have "AND" logic on this parameter, where the results returned are only those that meet all the values entered for this string.

For example: If the user enters "Biopsy", "Prostate", "Lateral" they would like each row to have all of these string values. Currently the report will pull records based on "OR" logic where it pulls records as long as one of these string values are found.

Is it possible to have "AND" logic on a multivalue parameter? If possible could you please provide examples to this solution. Thanks