Print Report Footer only IF certain value found in DETAILS

[borozu]

How to write condition to suppress/unsuppress report footer?

So in details I will have a lot of lines, and sometimes one of them will be ASSY. And ONLY when ASSY in details exist I would like crystal to print Report footer with barcodes for punching machine, otherwise suppress the section.

Is it possible?

[ido_millet]

Yes, create a detail-level formula that returns 1 if = ASSY and 0 otherwise.
In the report footer suppress expression, check to see if the MAX of that formula if 0 or 1.

[borozu]

Can you please explain more as I'm not so into CR? Where I can write "detail-level" formula?

[borozu]

So I created formula

if {V_BI_BAR_DETAIL.PWC} = "ASSY" THEN 1 ELSE 0

and in suppression for group footer:

{@display_punching_data} = 0

But still doesn't work 😞

Is it possible that it's because just one field in DETAILS section is this assy? And I have multiple details lines? Maybe it checks just the first one? Because formula works, when I put it on a report it does print 1 when ASSY line

Any ideas?

[ido_millet]

You forgot to check the MAX of that formula:

MAXIMUM({@display_punching_data}) = 0