Skip to Content
0
Jan 10, 2023 at 12:12 AM

Supressing a Group Header if every item in the Details Section is Supressed

72 Views

In Crystal Report 2020, I have a formula for supressing details based on certain criteria. I need to supress the Group Header if every item in the details is supressed based on that criteria. How do I do that?

the formula for supressing the detials is:

(ToText({MIMORD.lineNbr})<> "1.00"

AND

ToText(previous({MIMORD.compQty_form}))= "0.00"

AND

{MIMORD.wcId}<>previous({MIMORD.wcId})

)

OR

({MIMORD.compQty_form}={MIMORD.MIMOH.ordQty_form})

OR

if {EXTRAS.val5} = "" then FALSE

else if {EXTRAS.val5} <> {MIMORD.wcId} then TRUE

else FALSE

Screenshot of my report is below. I'd also like to supress Group Header #1 if Group header #2 is supressed for all records.

image.png

Attachments

image.png (34.7 kB)