Beating my head against the wall - need help on multiple to single report

[pityocamptes]

Ok, I have about 12 tables. I made a form, that has the main table as the container of the other sub forms. All of the tables are related to each other via the same foreign/primary key. For some reason I cannot create one single report that shows all of the data from all of the tables. I add the main table, works fine. Add the second related table, works fine, as soon as I add any table after this the report stops showing data. I'm not really sure what to do. Any help appreciated. Basically I want to pull all data from ALL of the tables onto one report. Thanks!

 

[pityocamptes]

Ok, I think I got it. I embedded sub reports into the main one and the data is showing. HOWEVER, I cannot see the label fields in the report. The only thing displaying is the data....

 

[vbaInet]

Oh, it has to be placed in the Report Header section or the Group Header.

 

[pityocamptes]

Oh, it has to be placed in the Report Header section or the Group Header.

Thanks! That worked. Now for some reason the sub reports always default to the right side where the slide bar has to be moved from right to left. How do I get rid of the slide bar so that nothing gets cut off? I formatted it so that all the data is within the page margins but for some reason the slide bar still shows, and it seems to be defaulting to a right to left scheme. Thanks again!

 

[vbaInet]

Set the SCROLL BARS property of the report to NEITHER.