summary of all total in last page

[rommeltm00]

hi guys

i have to gather all the page total on the last page
example

page 1 has a total of 25
page 2 has a total of 2
page 3 has a total of 5
page 4 has a total of 1

then on last page or summary band
it will display

page 1 = 25
page 2 = 2
page 3 = 5
page 5 = 1
total = 33

thanks in advance and more power. God Bless.

 

[JRB-Bldr]

Assuming that you can ensure that the amount of data on each page will not cause the Detail band to 'flow' onto the next page, you can do this in a couple of ways.

Method 1:
Do your 'page' value calculation before passing it to the Report Form in a field within the report's table/cursor and perhaps have a second field indicating which 'page' the value is for.

Then in the Report Form you can use that information directly within the Report Form's text boxes along with a Print When... expression.

Method 2:
Within the Report Form create various Variables which will calculate the appropriate summary values. Note this too may require a table/cursor field to differentiate 'page' values.

The in the SUMMARY band you can display each Variable with its associated 'page' number.

Good Luck,
JRB-Bldr

 

[rommeltm00]

i will try this one, thanks and God Bless