How to do numeric totals per PAGE

[dmcwhirt]

I have a database that prints a federal form. It requires that we sub total (at the bottom of the page) the value of the monetary contribution records that are printed on that page. The way we have set up the form, it shows eight records per page but as we add records to the database, the order of these eight records shift and change.

I know sub summary parts allow you to create a sub total as the sorted field changes value but this logic does not seem to be able to give a summary whenever the page breaks. Any ideas?

[LiveOak]

This is a little tricky and it does depend upon exactly 8 records per page. Create a field defined as:

CalcPage (calculation, number) = Int((Status(CurrentRecordNumber) - 1)/8 + 1)

Create a subsummary part for your page totals (you must still have exactly 8 records fit on a page) and place your summmary fields in this part. This subsummary part is sorted by CalcPage with a "page break after every 1 occurrences".

-bd

[dmcwhirt]

Thank you so much, this worked great!

I was trying to think how I could make the set of records on each page have SOMETHING in common, so that they could be broken up by a summary - and this is the way.

Simple but tricky math.

I did some experimenting and if anyone else wants to use this solution, you can use Int((Status(CurrentRecordNumber) - 1)/8 + 1)

or just Int((Status(CurrentRecordNumber) - 1)/8) because FileMaker will use the "Integer" zero as a value to break by.

If you have a layout that has a different number of records than 8 (I ended up using 9), just replace the 8 in the above formula with your number of records per page.

If you get any funny results, try putting the formula in as

Int(((Status(CurrentRecordNumber) - 1)/8) + 1). FileMaker seems to behave as you would expect with order of precedence with operators, but Excel does not and a situation may come up where this tip would help.

Thanks!