[RESOLVED] Two reports on one page in CRXI

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

Generally a subreport is linked to the main report via a common field. Based on your description, place the subreport in the Group Footer and link it on the TeamId. The subreport is then executed for each group and should be setup to only display data for that one team.

I don't have CR11 but in previous versions you right click on the subreport and use the Change Subreport Links menu item.

Well how easy was that! Thanks so much, Bruce!!!