I've created a Crystal Report to display the sum of labor hours taken from two separate, and disconnected data tables. The report is meant to compare the total labor hours from each of the tables, and identify discrepancies. The report information is grouped first by person, then by payroll date. In a main report, I've created the person and payroll date groupings, and a column which displays the sum of labor hours from one of the mentioned tables in the payroll date group's footer. In a second column, I've inserted a subreport which provides the labor hours summary from the second data table. This report works fine, but I'd like to condition the color of the payroll date field to change when there are discrepancies between the two labor hour column values.
To provide for a conditional check, I've created a shared numeric value in both the main report, and the subreport. In the subreport, I have a formula which sets the shared variable's value to that of the labor hours sum in the same group footer of the labor hours sum. In the payroll date of the main report, I check the shared variable's value to that of the labor hours sum in the main report, to conditionally set the payroll date's font color.
The problem is that the shared variable's value seems to lag behind the actual labor hours sum returned by the subreport, and is present during the conditional check for the following record. I've included a screenshot of the report's result.
Any help in understanding when the shared variable's value is being set would be much appreciated.