Per Page Subtotal
I'm creating a multi-page report that needs a per page subtotal in the footer of every page.
I've tried a few things, last of which, was to set a field on each record with get(pagenumber) and then create a relationship to use in a sum calculation, but FM will only set the first or last records when in Preview mode. Then I tried to determine the number of records that appear on each page, so I could then go through the records and mark each one with the page number, but my attempts at that aren't working either.
Any other ideas?
I'm using FM11 Advanced, mac and pc.