Newbies bstretch Posted January 26, 2002 Newbies Share Posted January 26, 2002 Dear All I am in need of some assistance in getting FileMaker to report the age champions from the school athletics carnival. I have summary fields that total all of each athletes points that they accrue and have got as far as making FileMaker 'highlight' the person who has the most points. That's in one layout. My problem is - I want to have another layout/report that only shows the top 3 age champions in each age group (opens, u17, u16 and so on). This is probably as clear as mud, but I think it's a fairly simple and easy thing to do. Is anyone able to give me some assistance in doing this? I can send the FileMaker file over to anyone who is able to help, it's small. With many thanks Cheers Ben. [email protected] Link to comment Share on other sites More sharing options...
Garry Claridge Posted January 26, 2002 Share Posted January 26, 2002 How do you determine the 'age group'? You can have a look at Summaries sorted on 'age groups'. All the best. Garry Link to comment Share on other sites More sharing options...
Gerd Muller Posted January 30, 2002 Share Posted January 30, 2002 hmmm, summarys would work, but how to find the top-3 of every age group? do a sort by age group and by points, loop trough your records, keep the top 3 and ommit all the others until you come to a new age group. Another approach: make as many self relation as you have age groups: create a global g_u16, fill it with "u16", create a self relation with this global to your age group field. You can catch all records with "u16" in a portal, sorted by points, where you can show only 3 records. Do so with all the other age groups, put all the portals on one layout. Gerd Link to comment Share on other sites More sharing options...
RussBaker Posted February 1, 2002 Share Posted February 1, 2002 Hi, I have done lots of work with race timing systems for Mountain Bike and Triathlons. What I would do is allocate the age group using a calculation (so that everyone from age 30 to 34 would be allocated to category "M30-34" - just an example, I know its a bit old for school). Then loop through a process which will - find all for that category, sort them out in decreasing points order, then allocate each one a place using a loop through those you've found and setting a "Place" field to be the StatusCurrentRecord Number. You now have each athlete allocated a place within their age category. Now, Find all athletes with a place of either 1, 2 or 3 (this gets you first, second and third); sort them by age category then place; and go to a summary layout which is using the age category name as the sub-summary header. Thats it. Link to comment Share on other sites More sharing options...
Fitch Posted February 4, 2002 Share Posted February 4, 2002 I answered this in another topic... ah, here it is. [ February 05, 2002, 02:30 AM: Message edited by: Fitch ] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8117 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