hi,

I have a report with numeric data that sorts by date.

I set a page break after 20 occurrence.

I want to add a subsummary row that summary the data in the page (as a running total)

thanks

Thanks in advanc

inbal

In attacment you can yourself to decide how many rows must be in one page when you want to print.

SubSummary.zip

Edited July 29, 200520 yr by Guest

Thank you for your response, but my problem is that I have to sort the report by the Date field and sub-summarise it by the page num.

is there a way to do it?

thanks

inbal

Exactly what information do you need to provide per page? Running balance is easy to do with a summary field (and you don't even need to hard-code the amount of records per page). Getting the total per page is much more complex.

Is this a single-user or networked solution?

Attached a pdf that looks like the form I'm trying to generate.

It's a form I have to submit to the IRS - all of my Income and Expenses in date order.

At the first row of every page there must be the Running total of the previous page, and the last row is the running total till this point.

Thanks

form.pdf

See if the attached helps.

balanceByPage.fp7.zip

Thank you very much

so simple...