Detail info on Group Footer

[angelaowb]

Is there a way to display a field from the first record of a group on a group footer as well as a field from the last record of a group on a group footer?

 

[synapsevampire]

Sure, create a formula to collect the value in the group footer, such as:

whileprintingrecords;
StringVar FirstValue:= {table.field}

Now in the group footer use:

whileprintingrecords;
StringVar FirstValue

For the last value just reference the {table.field} within the group footer.

So if you wanted it to display the entire range in a formula in the group footer, use:

whileprintingrecords;
StringVar FirstValue;
"For the range: "+FirstValue+" - "+{table.field}

-k