Hi All,
Firstly im using Crystal 9.5
Now, in my report, i have staff results where the staff names are actually grouped (so i can summarise their weekly stats).
The staff are then grouped under their supervisores names where again i have summaries for the supervisors.
Not sure if this can be done, but i want to conditionally format the highest value per group.
Heres my example
(Group 1) "Mr Supervisor" (Supervisor)
Calls Answered Calls Made
(Group 2) Staff 1 240 50
Staff 2 190 60
Staff 3 450 15
Staff 4 230 34
Staff 5 150 57
So, what can i do so that the result of "450" is formatted RED because it is the highest value for that group, keeping in mind, each of the staff results are groups and their results are summaries of their stats.
Cheers
please advise if i havent explained well enough.
Firstly im using Crystal 9.5
Now, in my report, i have staff results where the staff names are actually grouped (so i can summarise their weekly stats).
The staff are then grouped under their supervisores names where again i have summaries for the supervisors.
Not sure if this can be done, but i want to conditionally format the highest value per group.
Heres my example
(Group 1) "Mr Supervisor" (Supervisor)
Calls Answered Calls Made
(Group 2) Staff 1 240 50
Staff 2 190 60
Staff 3 450 15
Staff 4 230 34
Staff 5 150 57
So, what can i do so that the result of "450" is formatted RED because it is the highest value for that group, keeping in mind, each of the staff results are groups and their results are summaries of their stats.
Cheers
please advise if i havent explained well enough.