Sophisticated Reports Using Subreports

[buckibooster]

I am trying to create a two-page report. I used a document entitled "Sophisticated Reports: Multiple Columns and Subreports" by Rich Gorvin to get where I am now. I created two (2) separate tabular subreports representing each page then placed them into a master report using a common group header as suggested in the paper. While the two (2) separate subreports print out in the desired tabular format, they do not do so in the master report document. The first page prints out just fine but the second page prints out each line of the table separately. Can anyone suggest why it is doing this and how I can fix it? I am attaching a word document of the form I'm trying to re-create in Access. Unfortunately, the Access file is too large to attach.

 

[Geotch]

In design view of the report, go to the Property Box->Format Tab and look for Keep Together. It's either that or you have Can't Grow set to no.

It would be easier to figure out if you posted a picture of the design view of the report.

 

[buckibooster]

Geotch:

Thanks for taking the time to respond to my post. I tried your suggestions but they appeared to have no effect. I'm attaching the screenshots you requested. The first two (Page 2 Subreport - Page 1 and Page 2 Subreport - Page 2) contain the upper and bottom portion of the property sheet for the subreport that appears on the JSA Record - Page 2 Report. The next two (JSA Record - Page 2 Report - Page 1 and JSA Record - Page 2 Report - Page 2) contain the upper and bottom portion of the property sheet for the subreport that appears on the master JSA Record report. The last one (JSA Record Report - Page 1) contains only the upper portion of the property sheet for the master JSA Record report. I reached my limit of 5 files. I will try to upload the last file (JSA Record Report - Page 2) on a second message. I hope these are what you wanted. Thanks again for your help.

 

[buckibooster]

Geotch:

Here is the last screenshot file (JSA Record Report - Page 2). Thanks again.

 

[Geotch]

In the last picture shink both reports in the detail section so the are thin lines. Make sure you set them to can grow.
Let me know if that works.

 

[Geotch]

I just noticed another thing. You have JSA Record - Page 2 Report - Page 1.jpg set up as a sub report. So in the end you really have two reports that each have sub reports.

I'm not sure if you really need to set it up that way. Can you move just the reports to a database and upload it. I can move them around to show you how they should be. I've never had to do sub reports within a sub report.

 

[buckibooster]

Geotch:

No joy yet. Your most recent suggestion bunched up the report onto 7 pages instead of the previous 11 pages but the underlying problem still persists. I noticed that both subreports only print out 11 records. The page 1 table only has 11 records but the page 2 table has 20 records. Maybe there's a clue in that. As you requested, I eliminated the subreport for the page 2 subreport and packed the bare bones into the attached file for your review. I'm also attaching a pdf document of the form / report that I'm trying to recreate in access. Thanks again for all of your help.

 

[Geotch]

I uploaded your database with the changes and renamed the database (want to use it for a class).

Couple of things that I noticed:

Don't put anything in the page header or footer if you are using it as a sub report, it usually won't show up. Use the report header or footer instead. Right click on the report in design view to add the report header/footer.

JSA Record - Page 1 has text in the detail section. This will cause problems. I moved it to the report footer.

Sub reports shouldn't be put in the detail section of the report, that will cause the duplicates.

Depending on your queries, you don't need to link child and master fields. In fact I rarely do this, especially if I'm doing dashboards with different info that are unrelated on the same report (people reports, safety reports, production reports, etc.) I realize your data is related, but basically two different reports, just want to display them together. I deleted the links in the properties of the sub report.

I ended up just using two reports with major changes, both start with Z. Hopefully you can see what I did for future reference.

 

[buckibooster]

Thanks Geotch for all of your help. The problem is now resolved.