Formatting a group if any one record in details matches criteria 1

[dianemarie]

Hello, my report groups by client, and the details section (suppressed) has one to many orders for that client. I want the client group (header)to be highlighted if ANY of the orders in the detail section are of a specific type. I formatted the section with a formula, but it will only highlight the client if the first order it sees happens to meet the criteria. How can I tell it to highlight if ANY of the orders in details meet the criteria? The section formula is:

if {?Highlight Tests} = "Yes" and {Test/Cont} = "TEST" then Yellow else white

(Each order returns a field (Test/Cont) as either a Test or Cont) Thank you for any help.

 

[BobMarley]

You could do something like this
new formula
IIFF({?Highlight Tests} = "Yes" and {Test/Cont} = "TEST", 1, 0)

Add this forumal to the detail section and click on this field and create a summary and add this summary to the client header.

Then in the "format section" of the client group write

If (Summary Field)> 1 Then
crYellow
Else
crWhite

 

[BobMarley]

The last formula should go into the color tab

 

[dianemarie]

Worked great. Thanks Bob Marley!