Multiple values parameter comparing with part of field

building reports crystal reports
1

Hi,

I have database field which contains names (strings “A”, “B”, “C”, etc.) separated by comma (e.g. “A,B”, “A,B,Z”).

In CRXI I’ve created multivalues parameter to selecting these names.

How could I compare field value contains names that I choose by parameter. For exemple when I choose names “C”, “B” and “A” I want to see both of rows: “A,B” and “A,B,Z” and when I choose name “Z” I want to see only row “A,B,Z”.

Can I use wildcard?

When parameter doesn’t allow choosing multiple values then I could use this solution https://bobj-board.org/t/62494 but when parameter is multivalues then it doesn’t work.

TIA

//EDIT

My solution (formula):

Local NumberVar i;
BooleanVar contain := FALSE;
For i := 1 to Count({?Name}) do
    if ({table.names} like "*" & {?Name}[i] & "*") then
    (
        contain := TRUE;
        Exit For
    );
contain

But I wonder is it possible to omit the use of loop statement?

docent (BOB member since 2009-07-21)