Total by each page

[Johnny5]

If I have a report that runs lets say 10 pages, how do I get the total of lets say the cost field of those records for each seperate page?

If I use a summary field it gives me the total of the cost field for all records.

[Kent Searight]

Create a Found Set of the records you want to summarize.

[Johnny5]

But i want to print a report for all the records. There is no found set.

Are you telling me that I have to create a looping script that if there are 80 records, I have to figure out how many record will fit on each page and then do a find every time? Sorry, I am not sure what you mean.

[Brudderman]

Here is how I have done this in FM 6. There may be a better way in 8.

1. Create a field for print_page_# and a global field g_page

2. create a calc field for page_subtotal. It will sum your cost field through a self-relation (separate TO) based on print_page_#

Then set up a script to do the following:

3. go to layout to be printed

4. enter preview mode

5. go to last record/page

6. get current page number and set g_page with it

7. enter browse mode and go to last record

8. set print_page_# with value in g_page. this means that each record will have a value of which page that record will print on.

9. omit record

10. loop steps 4-9 and exit loop when found count = 0.

11. restore found count and print.

You should then be able to put the page_subtotal field in the footer. this is clumsy, and there may be a better way with new features in version 8. If so, hopefully someone will point it out.

James

www.BulletinInserts.org

www.james-mc.com

[Zero Tolerence]

Wrong topic sorry.

Edited November 15, 2005 by Guest