Printing grand totals just below last row of ON EVERY ROW

[France P.]

How can I make my grand totals (printed by the Last Page Footer in a simple list report) print just below the last data line printed, rather than at the bottom of the page?

[Alex G.]

Hi France,
if I understand the question correctly, then that is easy. Place a stripe just below the ON EVERY ROW trigger and place the total fields in it. Do not set the section property (stripes don't have it anyway). If you have running totals in ON EVERY ROW than you can use these variables here and they will contain the values of the last repetition which is the correct value. I hope this helps.

Kind regards,

Alex

[France P.]

Thanks Alex, does just what I want. attached is example or what this now does, i.e. totals immediately after last detail (on every row) line, not at bottom of last page. Ignore colours as this just in development currently.

cheers
Peter

[Alex G.]

Looks good, glad I could help.
Thanks for getting back,

Alex