Report with Sub-Reports

  • Thread starter Thread starter Xcelsoft
  • Start date Start date
X

Xcelsoft

I am using Access 2k on a XP workstation. The problem I
am trying to figure out pretains to Sub-Reports on a main
reports. The main report is basically a Work Order
report that shows the property address and is stored in
it's own table. I have two sub-reports included in the
Footer of the main Work Order report.

Sub_Report1 = Work Order Problem Codes (separate table)
Sub_Report2 = Work Order Service Codes (separate table)

The two sub-reports are each linked to the main report
via the Work Order ID that exist in all three tables.
The Work Order Report works fine until until the Sub-
Reports contain 10 line items for problem/service codes.
Access hangs on the "Fromating Report" step after the
source query runs and will not format, print or display
the report.

It's like based on the page settings once the detail in
the sub-reports will overflow to another page then it
hangs up. When you delete enough detail so the work
order will print on one page then it works.

Any ideas on how to correct will be appreciated.

Thanks,
 
Do you have Page of Pages in your report? If so, try removing this to see if
your issue is corrected.
 
Back
Top