AnsweredAssumed Answered

Trouble Creating Report using SubSummary

Question asked by ABuchtel on Jun 16, 2014
Latest reply on Jun 16, 2014 by ABuchtel

Title

Trouble Creating Report using SubSummary

Post

     Hello. I am using FMP 13. I have a Table for which I want to create a "Printer" Report. The Table is setup like this:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
                    Menu ID                     Event ID                     Item                     LineCost                     SubTotal*
                    M0010                     E01000                     LI00801                     1.00                     7.50
                    M0011                     E01000                     LI00803                     1.30                     7.50
                    M0012                     E01001                     LI00801                     1.00                     7.50
                    M0012                     E01001                     LI00911                     1.30                     7.50
                    M0014                     E01001                     LI00920                     1.40                     7.50
                    M0014                     E01001                     L100931                     1.50                     7.50

     *SubTotal is defined as a SUMMARY of LineCost

     I want to create a report for EACH "Event ID" that displays the individual Items in the "Body" and the SubTotal in the Footer.

     I have reviewed the Filemaker User Guide, and followed the steps for defining SubSummary parts. But apparently I'm missing some crucial piece of information, because even though I've set the "Sub-Summary" field to "Event ID", the resulting report displays only one record per form, instead of grouping the Items that share the same "Event ID". 

     In other words, I *expect* the report to look like this:

     ___ PAGE 1___

     E01000

          LI00801

          LI00803

     SubTotal: $2.30

     ___ PAGE 2___

     E01001

          LI00801

          LI00911

          LI00920

          LI00931

     SubTotal: $5.20

      

     But what I'm getting instead is:

     ___ PAGE 1___

     E01000

          LI00801

     SubTotal: $7.50

     ___ PAGE 2___

     E01000

          LI00803

     SubTotal: $7.50

     ___ PAGE 3___

     E01001

          LI00801

     SubTotal: $7.50

     ___ PAGE 4___

     E01001

         LI00911

     SubTotal: $7.50

     ___ PAGE 5___

     E01001

         LI00920

     SubTotal: $7.50

     ___ PAGE 6___

     E01001

         LI00931

     SubTotal: $7.50

      

     If someone would be able to provide a link or point me in the direction of where I might get myself straightened out, I would really appreciate it. Thank you. 

Outcomes