Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

jkaz

macrumors 6502
Original poster
Feb 3, 2004
386
2
Upper Mid West
I've looked everywhere to get some help, but haven't had any luck.

Here's the issue:

I'm trying to get my summary fields to shop up at the end all records, almost as if it were a record itself.

here's what i want it to look like:

johnson $5
smith $7
total $12

but when i set it up in the layout, here's what i get as a result:

johnson $5
total $12
smith $7
total $12


putting it in the footer won't work because these reports end up being 5 pages long.


so what i do is make 2 seperate layouts, one that looks like this:

johnson $5
smith $7

and one that looks like this:

total $12

then, what i do is print out the first report, 5 pages.

after that, i line up my second report(totals) so that it prints directly
below the last record, or in this example smith.


so i have to print the full report, then rig it so the totals will print on the last page.

i believe i came across the solution to this once while working on a layout, but i forgot what it is called.

any help would be much much much appreciated.

thanks!!!
 
I would recommend restructuring the database.

Make the individual items ordered a separate database called 'Line items'

Then in the Invoice database, make a portal for the Line Items
Put the summary field at the bottom edge of the portal and link it to the Line item database. Many of FM's example databases work this way.
 
pncc said:
I would recommend restructuring the database.

Make the individual items ordered a separate database called 'Line items'

Then in the Invoice database, make a portal for the Line Items
Put the summary field at the bottom edge of the portal and link it to the Line item database. Many of FM's example databases work this way.
Holy sliding fields, Batman. Rebuilding an entire database as relational with portals to solve a summary problem! Someone has a LOT of time on their hands here.... :D
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.