Highlighting Values in a Crystal Reports Crosstab based on sibling values
I have crosstab which has row columns indicating different classes, and then peoples names across the top.
Each field contains 2 values The first value is the number of hours spent in the class, the second field is the number of hours required for certification.
The Required field id my grand total summary.
In the cross tab expert the fields are defined as follows.
Command.descr -> a field containing the class names
Command.fullname -> a field containing students full names
Sum of Command.evlength -> summation of all time spent in a given course
Max of @required -> this formula returns the number of required hours based on the course name
I am trying to highlight
the field Sum of Command.evlength if it is greater than or equal to the value of Max of @required .
My solution was to perform background formatting. Right-Click on the Sum of Command.evlength field, select Format Field. Click the borders tab, check Background, and enter a formula.
The formula I was using is:
This is not the correct formula. My crosstab has been placed in the footer, which causes <@required> to contain the last value in the grid which in the above example is 2.
From my research I thought I would have to use GridRowColumnValue(row or column name) to access the value of <@required> in the crosstab, but I could not come up with the correct string to represent it.
Does anyone have a way for me to correctly perform this comparison?