SparrowHawk7
Feb 3rd, 2009, 07:04 AM
I'm new to CRXI but I've been fiddling around with sections and I am pretty sure this can be done but I'm not clear on exactly how. Basically the report is on baseball statistics drawn from a mdb database - there will only be 2 teams as each report is the stats from a particular game. The top of the page should show each player and their batting statistics - I've had no trouble doing this, grouping by team, sorting by player (or whatever field) and putting one team on their own page. However, what I would like is for the pitching statistics to be shown on the same page below the batting statistics. For those not familiar with baseball, pitching statistics are entirely different from batting statistics - however they are all stored in the same database table.
I created a subreport successfully for all the pitching statistics, showing only pitchers, but that report shows both teams. What I want is for each page on the report to show batting statistics on the top and pitching statistics on the bottom - and only for 1 team at a time. Since I already have the subreport designed, can I use a formula to get it to show only stats for the same team as the top report? Or is there a better way to accomplish this?
TIA
Ken
I created a subreport successfully for all the pitching statistics, showing only pitchers, but that report shows both teams. What I want is for each page on the report to show batting statistics on the top and pitching statistics on the bottom - and only for 1 team at a time. Since I already have the subreport designed, can I use a formula to get it to show only stats for the same team as the top report? Or is there a better way to accomplish this?
TIA
Ken