Jump to content
Sign in to follow this  
pacific707

subsort summary in a portal

Recommended Posts

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 by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

wow that portal does exactly what I want. edit(i spoke too soon)

2 questions

Sum(${date filtered {donations} per unique donor}:B: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 by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

hmm looked and looked but this is not what i need :B

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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.