having a problem with filemaker

Discussion in 'Mac Apps and Mac App Store' started by jkaz, Mar 10, 2005.

  1. jkaz macrumors 6502

    Joined:
    Feb 3, 2004
    Location:
    Upper Mid West
    #1
    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!!!
     
  2. pncc macrumors regular

    Joined:
    Jul 23, 2002
    #2
    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.
     
  3. CanadaRAM macrumors G5

    CanadaRAM

    Joined:
    Oct 11, 2004
    Location:
    On the Left Coast - Victoria BC Canada
    #3
    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
     
  4. CanadaRAM macrumors G5

    CanadaRAM

    Joined:
    Oct 11, 2004
    Location:
    On the Left Coast - Victoria BC Canada
    #4
    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
     
  5. jkaz thread starter macrumors 6502

    Joined:
    Feb 3, 2004
    Location:
    Upper Mid West

Share This Page