Formatting Page, press CTRL+Break to stop

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an invoicing report with a subreport. This is your standard invoicing
program. Within the subreport I have another subreport with comments about
this particular invoice. When I try and print the invoices, approximately 75%
print without a problem. The other 25% hang with the above message at the
bottom of the screen. I have reviewed the data in each individual file and
haven't found anything out of the ordinary. I have repaired and compacted the
database. I have created a new database and imported all the objects. I have
done a decompile. All of this was to no avail. I also have tried to run the
same data from 5 different machines with the same result. Has anyone run into
this problem so that they might point me in some direction. Thanks for your
prompt reply.
 
I now know it is the sub-report within the sub-report that causes the
problem. I deleted it and the all invoices ran fine. This 2nd sub-report only
has 3 fields:

Field 1 = key
Field 2 = invoice number
Field 3 = 250 character text field

All the data looks valid. Any ideas?
 
I discovered the problem. Although you can place a subreport within another
subreport, Access doesn't handle it well. It seems to get confused and go
into an endless loop and eventually crashes. Why some invoices were working
is because all the information could fit on one page while Access didn't know
where to break when it carried over multiple pages. The solution: imbed the
2nd subreport beneath the first subreport on the main report. Doing it that
way solved all the issues. Hopefully this helps someone else and they don't
have to waste 2 days figuring it out like I did.
 
Back
Top