Create report using two reports

S

Starbird

I'm trying to pull together two subreports from two separate queries into the
main report and have them link to each other. The ideal report would show
the orders from the branch offices (left side of the report) and compare it
to the billings for those orders(right side of the report). Where I got
stuck is on how to aligning orders with the billings for the each of the
branch office when on the billing side, the data set only contain records of
the one office that pay the bill.

Ideal Report:

1. ABC Worldwide (parent company)
unit shipped unit billed
billed $
Region 1 ABC-Japan 30 |
ABC-Ind 10 |
ABC-HK 20 | 60 $120

Region 2 ABC-US 50 | 50 $110

Total ABC Worldwide 110 | 110 $240

2. Co2.
3. Co3


Any advices/tips will be greatly appreciated.
 
S

strive4peace

Hi Starbird,

make a calculated control in your main report:

Name --> BillingID
ControlSource -- =
firstSubreport_controlname.report.BillingID_controlname

then, in the linkMasterFields and LinkChildFields for the
2nd subreport...

linkMasterFields --> BillingID
LinkChildFields --> BillingID_controlname_in_subreport

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Top