having a problem with filemaker

[jkaz]

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!!!

 

[pncc]

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.

 

[CanadaRAM]

Go to Help and review the differences betwen a Sub-summary Part and a Trailing Grand Summary Part. Also your Sort order is critical... it has to match what you set the Summary up as.

Thanks
Trevor
CanadaRAM.com

 

[CanadaRAM]

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....

 

[jkaz]

finally it works!!!!!


thanks!!!!