1 of 1 people found this helpful
Without looking at your file:
The problem is the grand total and sub summarys are only showing values for the last record.
This is expected behavior for a summary field from a related table. If the summary field were from the layout's table, it summarizes the records of the found set. If the summary field is from a related table, the total is calculated from the set of related records linked to one record of your found set and for a summary field in a footer or trailing grand summary, this will (in preview mode or when printing) be from the context of the last record.
The fix for this is either to change your layout context so that the summary field does not come from a related table or to do this:
Set up a calculation field that gets the summary value from the related record for each record in your found set. This can be a calculation that refers to the summary field in the related table or it can use an aggregate function such as sum, count, average.... to calculate the needed value. Then add a summary field to your layout's table that summarizes this added calculation field.