December 16, 200817 yr 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, 200817 yr by Guest
December 17, 200817 yr 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
December 17, 200817 yr 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
December 17, 200817 yr 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
December 17, 200817 yr Author 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, 200817 yr by Guest
December 17, 200817 yr Author Sum(${date filtered {donations} per unique donor}:amount) specifically what is the $ for?
December 17, 200817 yr 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
December 17, 200817 yr 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
December 17, 200817 yr Author 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
Create an account or sign in to comment