pacific707 Posted December 16, 2008 Share Posted December 16, 2008 (edited) I have been stumped on this for a while and can't find an example of what I am trying to accomplish. I have a calendar system and it keeps track of locations, time, and Date. I am just dealing with a people table and a shifts table. I want a portal on my layout dealing with people to show shifts grouped in location and totaling the time for that location like this Location 1 | 5:00 Location 2 | 3:00 Location 3 | 6:00 Location 4 | 9:00 but as close as i can get is... Location 1 | 5:00 Location 1 | 5:00 Location 1 | 5:00 Location 2 | 3:00 Location 3 | 6:00 Location 3 | 6:00 Location 4 | 9:00 Location 4 | 9:00 Location 4 | 9:00 Location 4 | 9:00 Location 4 | 9:00 totals are correct but not easy to look at. I can get the items to group but it ruins the totals.. any help appreciated. Edited December 17, 2008 by Guest Link to comment Share on other sites More sharing options...
Kevin Frank Posted December 17, 2008 Share Posted December 17, 2008 If I understand you correctly, you're trying to accomplish a summary report inside a portal. I built this demo right after FM7 came out to see if it could be done. In my case I wanted to see donors for a given date range, with one entry per donor along with the number of donations and total amount donated during that period. http://www.kevinfrank.com/dig-fm/kf-donations.zip HTH, Kevin Link to comment Share on other sites More sharing options...
Søren Dyhr Posted December 17, 2008 Share Posted December 17, 2008 Kevin It seems to me the shenanigans to save found sets in your second template doesn't rub off and influence the summaries made, shouldn't either a CF or a "Copy All Records" be instated to filter accordingly? --sd Link to comment Share on other sites More sharing options...
Kevin Frank Posted December 17, 2008 Share Posted December 17, 2008 Hi Soren, The demo showcases several techniques... the "found set" routines have absolutely nothing to do with the "report in a portal", which is filtered by a date range entered into a pair of global fields. HTH, Kevin Link to comment Share on other sites More sharing options...
pacific707 Posted December 17, 2008 Author Share Posted December 17, 2008 (edited) wow that portal does exactly what I want. edit(i spoke too soon) 2 questions Sum(${date filtered {donations} per unique donor}:amount) what is up with this calculation?! FMA9 wont even let me save it because "specified field cannot be found" is there an updated version of this?? The other question is.. I notice that some fields start with _c is this just to show its a calculation field? or is the underscore there for some other reason? Thanks! Edited December 17, 2008 by Guest Link to comment Share on other sites More sharing options...
pacific707 Posted December 17, 2008 Author Share Posted December 17, 2008 Sum(${date filtered {donations} per unique donor}:amount) specifically what is the $ for? Link to comment Share on other sites More sharing options...
Søren Dyhr Posted December 17, 2008 Share Posted December 17, 2008 The demo showcases several techniques... the "found set" routines have absolutely nothing to do with the "report in a portal", which is filtered by a date range entered into a pair of global fields. So I thought, but why not change the functionality to included this as well? --sd Link to comment Share on other sites More sharing options...
Søren Dyhr Posted December 17, 2008 Share Posted December 17, 2008 specifically what is the $ for? The reason is that the solution might be upgraded/migrated at some point and illegal namings have been carried on - such as reserved words: http://www.filemaker.com/help/05-Create%20a%20database41.html --sd Link to comment Share on other sites More sharing options...
pacific707 Posted December 17, 2008 Author Share Posted December 17, 2008 hmm looked and looked but this is not what i need you are missing the part where i need to sort each location so on the layout based on people it can show Joe Smith location 1 | 8:00 location 2 | 3:00 location 3 | 4:00 from a layout based on shifts where when sorted and other names removed would look like this Joe Smith | Location 1 | 2:00 Joe Smith | Location 1 | 2:00 ___I need this data to be 1 line in the portal Joe Smith | Location 1 | 2:00 / Joe Smith | Location 1 | 2:00/ Joe Smith | Location 2 | 2:00__ this data be 2nd line Joe Smith | Location 2 | 1:00/ Joe Smith | Location 3 | 2:00__ and 3rd Joe Smith | Location 3 | 2:00/ So I need the portal to show who spend how much time at each location. This is a little different than your example because your example doesn't subsort Link to comment Share on other sites More sharing options...
pacific707 Posted December 17, 2008 Author Share Posted December 17, 2008 ahhh solved with join table thanks all love those join tables Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5607 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