AnsweredAssumed Answered

Group Totals/Breaks

Question asked by cpking on Jan 24, 2019
Latest reply on Jan 24, 2019 by beverly

As an old MS Access person, I sometimes find what should be the easiest thing to do in Filemaker the most arcane. So with apologies, I need help with grouping...

 

I have a few tables with relationships for Keys to our buildings. In my report layout, I have leading sub-summary for BUILDING, and a second sub-summary for KEYSTAMP. The BODY has relevant fields (i.e., Rec_ID, Keystamp, Person's Name, Date Issued, etc.).

 

Following BODY, I have a sub-summary for KEYSTAMP and another sub-summary for BUILDING. In each of those parts, I have a summary field in each of these following sub-summaries which are defined in the table as count.

 

My goal is to have a report print as follows:

 

BUILDING 1

     KEY1

          NAME                    DATE ISSUED         

          NAME                    DATE ISSUED         

          NAME                    DATE ISSUED         

                    Total KEY1               XX

     KEY2

          NAME                    DATE ISSUED         

          NAME                    DATE ISSUED         

          NAME                    DATE ISSUED         

                    Total KEY2               XX

                    Total BUILDING 1     XX

BUILDING 2

     KEY1

          NAME                    DATE ISSUED         

          NAME                    DATE ISSUED         

          NAME                    DATE ISSUED         

                    Total KEY1               XX

     KEY2

          NAME                    DATE ISSUED         

          NAME                    DATE ISSUED         

          NAME                    DATE ISSUED         

                    Total KEY2               XX

                    Total BUILDING 2     XX

Outcomes