Access Report with multiple sub-reports in detail section

[Lance]

I have built an access report containing query results as well as two
sub-reports in the details section. I am working under the assumption that
there are always records retried for the 1st sub-report but there are not
always records for the 2nd sub-report.

Now the problem...the 1st sub-report works fine, unless the 2nd sub-report
has records. When the second sub-report has records, the report no longer
prints the 1st sub-report. So the report appears to have an either/or option
going on; however, I need both sub-reports to always print.

Thanks in advance for any help you might be able to offer!

 

[Allen Browne]

The solution might be as simple as setting the Can Grow property of the
Detail section to Yes so it can expand and accomodate both subreports.

But it's probably better to place each subreport in a section of its own. If
the main report is bound to a table, in the report's Sorting'n'Grouping box
(View menu in report design), choose the Primary Key field, and set Group
Header and Group Footer to Yes. You now have 3 sections that occur for every
record, so you can put the subreports into whichever suit you.

 

[Lance]

Thanks for the help. After adding additional grouping to the report I was
having the same result. After combing through the records I realized that the
error was at a record level and not the report level. When using the correct
data sample the report looks fine.

Thanks for your help!