Title

Summarizing a List

Post

Need to summarizing a list of projects by showing the same project title info only once then list a series of records with the same project name but not repeating the project title info. Then for the next project title info once, with related detailed records. What would be simple way to do it, or a hard way to do it?

While in layout mode, add a sub summary layout part "when sorted by Project Title".

Put the Project Title field in this sub summary layout part.

Put the "detail" fields for each of the records with this same project title in the body layout part.

Sort your records by Project Title to make the sub summary layout part appear as a "sub head" above each group of records with the same Project Title.

If you define summary fields in this table, you can add them to the sub summary layout part to show a subtotal based on all records in your found set with the same project title. Put the same fields in any other layout part and they'll show a grand total based on all the records in your current found set.