I have this formula called @suspect in my detail section which allows me to show up to 4 lines of an 80 character field from up to 4 different records in a VFP 6 table if the field is not blank or empty.
The detail section shows me what I want, but how can I get the results from this formula to appear in the group section because the detail section is suppressed.
For now, I have the same formula in the group section, but the results are unreliable. Any help is appreciated. Still looking for answers on Crystal website and books.
Here's the Crystal formula that works in the detail section, but not in the group section. What should it look like in the group section to pull the results from the formula in the detail section? Thanks very very much!
Whileprintingrecords;
NumberVar counter;
StringVar suspect_tube1;
StringVar suspect_tube2;
StringVar suspect_tube3;
StringVar suspect_tube4;
If TRIM({tubestats.slist}) <> "" then counter:=counter+1
else counter:=counter;
If counter=1 then
suspect_tube1:=TRIM({tubestats.slist})
else
If counter=2 then
suspect_tube2:=TRIM({tubestats.slist})
else
If counter=3 then
suspect_tube3:=TRIM({tubestats.slist})
else
If counter=4 then
suspect_tube4:=TRIM({tubestats.slist});
If counter > 0 then
suspect_tube1+CHR(13)+suspect_tube2+CHR(13)+suspect_tube3+CHR(13)+suspect_tube4;
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.