Highlight Group if... 1

[drinker]

Crystal 8.5

I have a group

GroupName ({REQUIREMENT.WORKORDER_BASE_ID})

in which I have a Field of {PART.QTY_ON_HAND}

What I would like to do is when none of the returns for
the field {PART.QTY_ON_HAND}
in the group
GroupName ({REQUIREMENT.WORKORDER_BASE_ID})
show a 0 or less then I would like to highlight the
GroupName ({REQUIREMENT.WORKORDER_BASE_ID})
such as an * or maybe have it be red and bold.

EX.

W1235 W8757

234 674
456 743
342 0
567 567

In this example I would like the first group of W1235 to be somehow highlightd because the field of {PART.QTY_ON_HAND}shows no 0's
Thank You for any input on this one.

 

[SmpTraining]

Try this against the X+2 conditional formatting for the background color (or font color) setting for the group header.

if minimum({PART.QTY_ON_HAND}, {REQUIREMENT.WORKORDER_BASE_ID}) > 0 then crSilver else crNoColor

I've not tested this but it should be close.

Steve Phillips, Crystal Trainer/Consultant

 

[lbass]

Create a formula {@zero}:

if {PART.QTY_ON_HAND} <= 0 then 1

Then go to the section expert->group header (assuming this is where your groupname is)->color tab->background->x+2 and enter:

if sum({@zero},{REQUIREMENT.WORKORDER_BASE_ID}) = 0 then crYellow else crNoColor

-LB

 

[drinker]

Thanks SMPhillips! Worked Great. Have a good holiday!