Skip to Content
0
Sep 24, 2008 at 02:11 PM

How to display the last value of a field in a group in the group header

524 Views

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.

Fuskie

Who is constantly amazed at the ability of users to request report features that are not easily implented through Crystal Reports...