How to display the last value of a field in a group in the group header
I need to display the last quiz score from a group of quiz scores as part of the header of a group of units (the quiz score values are in the detail record). I can not use the group footer, which would be the natural place to find the last value. It must be in the group header because there will be a subsequent group within the unit group. In other words, the grouping is as follows:
Unit Group Header (Display last quiz score in unit) SubUnit Group Header (Display other detail summaries) Detail Record (including quiz score) SubUnit Group Footer Unit Group Footer
While there is a minimum/maximum summary function, there is not a first/last function.
Who is constantly amazed at the ability of users to request report features that are not easily implented through Crystal Reports...