Top 10 Conditional Formatting

[Former Member]

I am using Crystal Reports 2013. I have 6 fields that make up the data of my groups. What I would like to do is highlight the top 10 numbers between these 6 fields. Theoretically it is possible to have all 10 in one column. I have included a picture to hopefully help explain my report. Any ideas on if this is possible in Crystal Reports?

[Former Member]

Kelsey

This would be my approach.

Create a new formula  field that uses a cascading series of "If"  statements to find the largest value of the different fields  in each row.  -

Then you can sort all the rows in the group  by that new formula result.

You can then use a formula in the format where you test to see if the value of the field is the same as the value of  result of the new formula  and if true then turn on the yellow background .

BUT....... 

Be careful of the timing of the 2 different formulas,   You want to be sure the first formula is processed before the second,  so you may need to add a section to assure that happens in the correct order.

.....    and there may be times when more than one column has that value    but this should work for that case as well.

  Ted

[former_member11696]

Moved to CR design forum