multivalue fields 2

[Zeug32]

Crystal 8.5
Database Pick D3

I'm trying to find a formula that will help me display data from a multivalue field when using a stringvar formula.

Database shows:
Example 1 Example 2
L# Code L# Code
1 INV 1 PRIM
2 SEMI 2 INV
3 PRIM 3 PRIM

In report Header I have:
whileprintingrecords;
stringvar Invitation;

In Details:
whileprintingrecords;
stringvar Invite =
IF {Table.Field} = "INV"
then {Table.Field}

and Footer:
whileprintingrecords;
stringvar Invitation

The report only displays "Invitation" if INV is on the first line in the db. Example #2 will show a blank because INV is on the second. I'd like to get the report to display "Invitation" if INV is on line 1,2 or 3.
Hope this makes sense.

Thanks,

 

[synapsevampire]

Odd request.

Since those are your choices, you can use the following in the report footer:

If minimum({Table.Field}) = "INV" then
invitation.

Not sure why you're referencing lines here.

If you want it to display at the detail level, just use:

IF {Table.Field} = "INV" then
"Invitation"
else
{Table.Field}

-k

 

[lbass]

Try the following for your detail level formula:

whileprintingrecords;
stringvar Invite;

If instr(Invite,"Inv") = 0 and
{table.field} = "Inv" then
Invite := Invite + {Table.Field};

-LB