Multiple Reports on One Page

[iowadonnie]

I have run into a problem. I have multiple reports (4) that I wish to add to one page, but the reports each are grouped by horserace. I have built 4 queries and four seperate reports. Now I wish to add the 4 reports to one page (there are only about 10 rows per report, so stacking them one on top of the next would leave plenty of page room) and maintain the "page grouping" by race. So one report has Trainer information, one has horse information, the 3rd has Jockey information, and the last is Last Race info. How do I put all 4 reports stacked on one page and still maintain my one race per page set up? Any help would be GREATLY appreciated...I have been pulling my hair out for about 2 weeks now trying to make this work! It is possible...no? THANX!!!

 

[KenReay]

Have you tried making a 'main report' (which is blank) and adding your four reports to it as sub reports?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[iowadonnie]

Ken...
Thanks for your QUICK reply. Yes, I have tried that...as long as I put two reports horizontally next to each other, both reports will display properly. But when I stack one over the other in the Detail area, the first one processes fine, but the second one doesn't show until after the first reports last page.
I really do need to stack all four reports, one on top of the other.Any other thoughts would be greatly appreciated!

 

[dhookom]

You need to add a record source of distinct races to your main report. Then set the Link Master/Child properties of the subreports to the RaceID (or whatever) to limit the display in the subreports to the current Race.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[iowadonnie]

Thanks for the help....works perfectly now!!