I have created a report that displays a grid in the Page Header/Details sections. Basically, the header info is in the Page Header and the database fields are in the Details section. This grid works fine and displays the data correctly.

The issue is with the database fields that are in the Report Footer. They display correctly when there is only 1 row in my grid but when there are multiple rows, none of the database fields in the Report Footer are displayed.

I have tried setting/unsetting numerous properties but still an issue.

database fields from my datatable

I think you're right because the data for the fields in the Report Footer are on the 1st row.
Can you tell me the formula I need for these fields to look at the 1st row please