CRICKET STATZ

Mark The simple answer is that I did not appreciate that each team/club had a "List" which when combined with "Active" players provides the drop down lists for each team. Once I cleared out all the dead wood from each team and ensured everyone was active and had the right (correctly spelt) alias, everything slipped into place. Simple not going deep enough into the product.

Our Association construct is Association - Club - Team. Basically Cricket ADF is the Association, The Services are the Clubs and they each have two main teams. The Single services are very independent and are responsible for managing their own teams etc As the Association, Cricket ADF also manages two Rep Team (ADF Men and Women) and for special events and tournament, a few others (eg the ANZACs, Defence World XI, Presidents XI etc). For the ADF teams I guess it would work but for the other Rep Teams, they often contain other players that are not members of the Cricket ADF Association as such and are not included in our reporting and often are not eligible for awards etc. In v11, we used the Rating set up so I could run reports for a season, tour, or the entire history and only get results containing our direct members which aids in my reporting. For our presentations last year, performance awards (batting, bowling, fielding etc) was only open to the Army, Navy and Air Force players and not the visiting side (who would have probably come 1st, 2nd and 3rd in most categories). While I can muck about post carnival and do a dump to Excel and filter the Non-ADF folk out, it adds a number of steps to the task.

This would make things particularly messy. I am still a fan of the Player Rating fields (I only used Ratings 1 - ADF, 2 - NZDF and Blank everyone else). All it needs is to have some sort of Player Detail specific field in the report filters. An alternate solution, while not catching everyone, would be to be able to select multiple teams in the filter (like the Divisions). This might still catch some ring ins or miss a few games for people who substituted for other teams but it might work until we can add a Player Detail specific filter.

Mark The pools field won't work as it is not a person specific field rather its a match specific field. Basically, I want to be able to set the reports up such that when people go into the Players and Officials page they are only present with the ADF Players (not necessarily people who have played for the ADF Team but all the members that have represented When people the Australian Army, Navy and Air Force. If you look at the first screen of our list, the first Cricket ADF, Australian Army, Royal Australian Navy or Royal Australian Air Force person doesn't show up until well down the list. Hence why I would like to be able to create a background filter for the ADF Pers. Also, would it be possible to have a filter system on the public side that allowed you to filter by club, season, active, and pool? D

Mark That will only provide the details for player who have played for the ADF. By ADF players I actually mean players who are members of the ADF (including those who have only played for their respective service). Cricket ADF is the overall Association, while Army, Navy and Air Force are the clubs but we often have 'visiting'clubs in our competitions and our Rep Side plays external clubs. When using the v11 database, we simply gave all ADF personnel a 'Rating 1"and used that as a filter when running statistical reports. That no longer looks like it is available.

Mark How do I filter the lists that are presented to people going to our site so that it only shows the ADF players in the list rather than all the opposition players as well? D