Subreport Link Not Working

[mwake]

I'm using CR2008 and have an Oracle 11g db as my data source. I'm creating a new booking report which is grouped by rep, by territory, booking rep id, product level 5, and product level 6. It is supposed to show both MTD and YTD booking quantities for product level 5 with drilldown available into level 6. The MTD and YTD are different fields and not on the same line, which is why I am grouping at the product level 5. In addition to this, there is also a YTD summary by month for each rep:

Sales Rep info is located in Page Header A, Sales Rep Name is in Page Header B for page 2+, and column headers are in PHC. The report body should look like this:

Territory 1
01234(booking id) Joe Blow(booking rep id
Widgets(prod level 5) 25(MTD) 100(YTD)
Widget-steel(prod level 6) 15 75
Widget-alum 10 25

Territory 2
0567

YTD Product Summary
January FY13 1000
February FY13 700
March FY13 1200

I created a subreport for the YTD Summary from the same table as the booking report, inserted it into the booking report into GF1 and linked by rep, but it shows me every product summary for each rep rather than showing only the linked rep. I am using the same formula as a group name for Sales rep for bothe reports. The subreport has only one grouping at the rep level. Does the link not work because it's the same tabel for both reports??

 

[lbass]

If you go into the subreport->report->selection formula, what is the formula there?

-LB