Crystal Reports 2014 Suppressing lines based on formula max value

[jchewsmith]

I have a report that groups by job then department cost. I have a formula in the grouping that calculates the % of the department cost of the total job cost.

I would like to suppress all of the department lines except the one with the largest % of total cost. Is there a way to do this?

Job 123
dept a 10%
dept b 20%
dept c 60%
dept d 10%

I want to suppress all lines on this job except dept c (the highest %)

 

[SkipVought]

Hi,

How about posting in a Crystal Reports forum?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[jchewsmith]

So sorry, I guess I wasn't paying attention.

Thanks