subsummaries at the end of the report

[minnesota1972]

Hello to all

I am new to FM so I would appreciate the help.

Is there a way to get all of my sub summaries in my report to all appear at the end of the report?

I kind of want a summary of my sub summaries to display as the last thing on my report?

How do I accomplish this?

John

[Russell Barlow]

Hello to all

I am new to FM so I would appreciate the help.

Is there a way to get all of my sub summaries in my report to all appear at the end of the report?

I kind of want a summary of my sub summaries to display as the last thing on my report?

How do I accomplish this?

John

Check out Part Definitions and specifically a Trailing Grand Summary.

http://help.filemaker.com/app/answers/detail/a_id/6200/~/example-of-a-subsummary-report-showing-subtotals-and-grand-total

[minnesota1972]

Thank you Russell Barlow for sharing the information.

I fear I may have expressed my question badly.

I know how to get a sub summary at the end of my sub summary section.

I want to have all the sub summaries report at the end of the report as well as the end of the section.

I followed the instructions on the link and I cannot get my results to reflect this following outcome:

Group A / sub summary part

Apples 5

Bananas 3

Group A Total 8

Group B / sub summary part

Carrots 7

Radishes 9

Group B Total 16

/ End of report totals

Group A Total 8

Group B Total 16

Grand total 24

Is there a way to do this?

I appreciate your continued help and patience

John

[Vaughan]

A layout can only contain two sub-summary parts for each field (one leading and one training) and your design requires three. A work-around might be to create a calculation field equal to the "Group" field and use this for the end of report totals.

Otherwise re-design the reports to only use 2 sub-summary parts for the Group field, or generate and print the end of report totals separately using a different layout.

[minnesota1972]

A layout can only contain two sub-summary parts for each field (one leading and one training) and your design requires three. A work-around might be to create a calculation field equal to the "Group" field and use this for the end of report totals.

Otherwise re-design the reports to only use 2 sub-summary parts for the Group field, or generate and print the end of report totals separately using a different layout.

Thank you for the suggestion and work around.

I will try them out right away.

Your replay raises one more question: Is something like the following possible

Apples 5

Bananas 3

Group A Total 8

Carrots 7

Radishes 9

Group B Total 16

/ End of report totals

Group A Total 8

Group B Total 16

Grand total 24

Or how about this?:

Apples 5

Bananas 3

Carrots 7

Radishes 9

/ End of report totals

Group A Total 8

Group B Total 16

Grand total 24

Please advise when you have the time.

Thank you

John

[bruceR]

A layout can only contain two sub-summary parts for each field (one leading and one training) and your design requires three. A work-around might be to create a calculation field equal to the "Group" field and use this for the end of report totals.

Otherwise re-design the reports to only use 2 sub-summary parts for the Group field, or generate and print the end of report totals separately using a different layout.

Don't forget that we have merge variables available now.

Like this:

GroupReport.fp7.zip

[bruceR]

Thank you for the suggestion and work around.

I will try them out right away.

Your replay raises one more question: Is something like the following possible

Apples 5

Bananas 3

Group A Total 8

Carrots 7

Radishes 9

Group B Total 16

/ End of report totals

Group A Total 8

Group B Total 16

Grand total 24

Or how about this?:

Apples 5

Bananas 3

Carrots 7

Radishes 9

/ End of report totals

Group A Total 8

Group B Total 16

Grand total 24

Please advise when you have the time.

Thank you

John

Use conditional formatting and merge variables, gets results like this:

[minnesota1972]

Use conditional formatting and merge variables, gets results like this:

Oh wow!

I haven't figured out totally what it's doing yet... but I like it.

It worked seamlessly in my DB

Thank you for taking the time to put that together for me.

The help was invaluable.

I'm now going to take some time and try to decipher all the different parts to better understand what is at play.

Have a great day.

John

[Vaughan]

Excellent solution Bruce.

[bruceR]

Excellent solution Bruce.

Thanks!

Here are some variations, including collecting the resulting data, see last layout.

GroupReport.fp7.zip

[minnesota1972]

Thanks!

Here are some variations, including collecting the resulting data, see last layout.

GroupReport.fp7.zip

Hi again

I spoke too soon.

I've got weird things happening that I can't seem to diagnose.

If I click preview and then print the report = No problem

If I click preview and then flip thru the pages directly to the last page = no problem

If I click preview and then flip thru the pages directly to the last page and then flip back to the page with the group heading and then flip back to the last page = the group heading that I viewed twice shows twice on the ending summary section.

Essentially what is happening is this: If I flip thru the pages of my report the number of times I view each group is the number of times that group's info is repeated in the end.

The same thing seems to happen to your example. I increased the size of everything so it stretch to multiple pages.

Is there a way to correct for this?

Please advise if you have the time.

Thank you.