I am trying to pull Club Records, but I cannot seem to filter opposition out of the data. For example if I pull a list of centurions it also includes centurions from opposition teams which is not what I want as I just want my clubs players?
top of page
Top Suggestions
bottom of page
Hi Michael,
Can you post up the URL of your report and we will take a closer look?
http://www2.cricketstatz.com/ss/runreport2.aspx?mode=43&club=17245&grade=0&ground=&pool=&sday=1&smonth=Jan&sYear=1800&eday=1&emonth=Jan&eYear=2100&finals=0&team=0&oppteam=0&round=&mininns=0&minruns=0&minovers=0&fowpos=0&batpos=0
I am hoping this will show what I mean, it includes other clubs achievements against my club.
Hi Michael,
When you run the report, are you selecting the "team" option?
Actually, the better question - leave the team: as "all teams" but are you selecting the specific club at the top?
I think I can see the issue.
You have named your database Plymstock Cricket Club but that is the whole database.
I see that you have around 4 "plymstock" clubs. If you select any of these as the "Club" for the report then it will filter out the opposition.
You probably should have just set up one Plymstock club (and just name it Plymstock) and then the others could be set up as teams. That way, you can just select Plymtock and it will include all your teams. It is not too late to do this.