minnesota1972 Posted January 31, 2011 Share Posted January 31, 2011 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 Link to comment Share on other sites More sharing options...
Russell Barlow Posted January 31, 2011 Share Posted January 31, 2011 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 Link to comment Share on other sites More sharing options...
minnesota1972 Posted February 1, 2011 Author Share Posted February 1, 2011 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 Link to comment Share on other sites More sharing options...
Vaughan Posted February 1, 2011 Share Posted February 1, 2011 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. 1 Link to comment Share on other sites More sharing options...
minnesota1972 Posted February 1, 2011 Author Share Posted February 1, 2011 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 Link to comment Share on other sites More sharing options...
bruceR Posted February 2, 2011 Share Posted February 2, 2011 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 Link to comment Share on other sites More sharing options...
bruceR Posted February 2, 2011 Share Posted February 2, 2011 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: Link to comment Share on other sites More sharing options...
minnesota1972 Posted February 2, 2011 Author Share Posted February 2, 2011 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 Link to comment Share on other sites More sharing options...
Vaughan Posted February 2, 2011 Share Posted February 2, 2011 Excellent solution Bruce. Link to comment Share on other sites More sharing options...
bruceR Posted February 3, 2011 Share Posted February 3, 2011 Excellent solution Bruce. Thanks! Here are some variations, including collecting the resulting data, see last layout. GroupReport.fp7.zip Link to comment Share on other sites More sharing options...
minnesota1972 Posted February 4, 2011 Author Share Posted February 4, 2011 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4824 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now