I'm wondering if someone can tell me if what I want to do is possible and point me in the right direction.

 

I'm creating a list style report of postal information with six fields.  I want to create a sub summary with the total of the numeric values 6th field when grouped by the 4th field. However, I only want the subsummary to appear when there is actually more than one field to total up.

 

Most lines of the report will look like this:

 

Job   State   Zip      CRRT  Week  Count

XYZ    NJ    07891   C001    1          50  

XYZ    NJ    07891   C002    1          50

XYZ    NJ    07891   C003    1          75

 

 

 

However, there will be places where the CRRT repeats over different weeks.

 

 

XYZ    NJ   07891    C001  1        50

XYZ    NJ   07891    C001  2        75

XYZ    NJ   07891    C001  4        25

 

 

When this occurs, I would like a subsummary to total the count field sorted by that CRRT. Something like this:

 

 

XYZ NJ 07891 C001 1 50

XYZ NJ 07891 C001 2 75

XYZ NJ 07891 C001 4 25

 

 Total of           C001        150

 

 

 Obviously, I can create a summary field and put it in a sub summary part, but it will appear after every line of the report. I want it to only appear when required. Is this possible? Any and all ideas are appreciated! 

Automatic message

This topic has been moved from "Advanced & Developer Features" to "Layouts".

 

The Advanced & Developer Feature topic is for discussion about the special tools that are part of the Advanced Edition of FileMaker.