datalink Posted December 28, 2016 Share Posted December 28, 2016 A DBMS that we're working on deals with routing trucks. In the body of the report each record represents a stop for a truck. There is a calculation field there that returns the number of packages to be offloaded on that stop. The body part is followed by two sub summaries. The first summarizes by route and a summary field positioned there returns the number of packages that will be put off that truck on all of the stops on the route. The second sub summary part is by date. I've placed that same summary field into the second sub summary part in an effort to have it display the number of packages that will be off loaded at all stops, on all routes on that day. In that part the summary field returns the value of the last route on that day and doesn't total across all routes for that day. What am I doing wrong? The summary parts appear correctly. I just can't seem to get the summary field to work in the second sub summary. Thanks in advance for any suggestions. Link to comment Share on other sites More sharing options...
Steve Martino Posted December 28, 2016 Share Posted December 28, 2016 When you say it's not working, are you sorting on whatever field the second sub summary part is based on? So with 2 sub summary parts, your report would need to be sorted by both. The other thing to try, is instead of the second sub summary part, did you try a trailing grand summary part and put the field into that part? Link to comment Share on other sites More sharing options...
datalink Posted December 31, 2016 Author Share Posted December 31, 2016 Thanks for your reply. Yes, it is sorting on both sort requirements and both parts are appearing in the report layout where they should so I feel pretty confident that the issue isn't the sort. There is a trailing grand summary part with the same summary field in it. It has the same problem and only shows the total of the last route on the last day. Link to comment Share on other sites More sharing options...
datalink Posted January 3, 2017 Author Share Posted January 3, 2017 I seem to be having issues with a pretty basic filemaker task, but I can't seem to work through it on my own. I'm hoping the forum can help sort me back out. A system that I am working on handles routing of delivery trucks. In the body of the report each record represents a stop that a truck must make and at that truck stop level is a number field that details the number of packages to be left at that stop. There are two sub summary parts. The first summarizes by route and the second by route date. The first summary part should summarize the number of packages on each route. The second summary part should summarize the number of packages to be delivered on all routes on a given day. I've attached a scaled down prototype showing what I've tried to do. In the prototype the parts are not appearing in the correct order with the date summary appearing ahead of the route summary and worse, it isn't summarizing properly. Any suggestion about why it is failing would be much appreciated. Prototype.fmp12.zip Link to comment Share on other sites More sharing options...
comment Posted January 3, 2017 Share Posted January 3, 2017 This appears to be a duplicate post:http://fmforums.com/topic/100864-second-sub-summary-problem/#comment-459243 Link to comment Share on other sites More sharing options...
datalink Posted January 3, 2017 Author Share Posted January 3, 2017 Sorry about that. It is a reworked version of an earlier post. It is bit more thought out than the last one and includes a prototype. I wasn't sure how to boost it up into the feed again so that more folks might take a look at it. I've been unable to resolve the issue. Link to comment Share on other sites More sharing options...
Steve Martino Posted January 3, 2017 Share Posted January 3, 2017 Is this what you are looking for? Little confused about your description. If it's not, maybe mock up one on Excel. PrototypeModSM.fmp12 Link to comment Share on other sites More sharing options...
Lee Smith Posted January 4, 2017 Share Posted January 4, 2017 Hi datalink, I merged your two questions. Please do not start a new topic when having additional ideas on a question that you posted. Lee Link to comment Share on other sites More sharing options...
LaRetta Posted January 4, 2017 Share Posted January 4, 2017 4 hours ago, datalink said: I wasn't sure how to boost it up into the feed again so that more folks might take a look at it. I've been unable to resolve the issue. Hey there, Datalink! In future, you can always post again on your thread, even just typing 'bump' ... which will bump it up into everyone's view again. It is easy, because we all (including you) are busy, for things to just slide by. By keeping everything in a single thread, it helps us in by reading what others have suggested and your other discussions about the issue. :-) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2667 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