Sub Reports not printing

[RedBlackSoftware]

Hi

I am having a problem with printing an access report.

Background to the problem.
The software is a large Access database running on machines with Office 2003 SP3 inc Hot-fix installed. The main purpose of the software is order processing and it also produces invoices in the form of Access reports. This invoice report is the one causing the problem. The report has around 14 sub reports which are unbound. When the report opens it looks at a table which has the setup information for that client which tells it the sub reports to bind each of them to. This is so the invoice can be customisable for each client without creating endless reports with each combination. All the sub reports run off data stored in 3 temporary tables which are built just before the report is run. These tables contain every piece of data to be displayed by any of the sub reports.

The Problem
When printing a batch of these invoices they start off ok and print out showing all the information. Then as they go on they sometimes are printed out with some of the sub reports not showing. This gets worse and worse with each one until the report just doesn’t show anything. This is very intermittent but is a real problem as the client has to check all the invoices every time to make sure they have printed correctly.

Occasionally an error 7895 “Unable to create Window” appears which I believe is memory related after looking at this on the internet.

Has anyone else had this problem before or have any idea about how this could be resolved? If you need any more information let me know and I will try to provide it.

Chris

 

[dhookom]

Are all records for all reports and subreports created at the same time prior to any report opening for all invoices?

Have you considered binding all subreports and then making some visible or invisible based on the setup information for the client?

Duane
Hook'D on Access
MS Access MVP

 

[RedBlackSoftware]

All the records are created prior to the report being run. I have been storing the history of this table and when i look at it after the problem has occured the data that is missing off the report is there in the table.

Having all the sub reports on the report and then changing the visibility is an option but i am not sure if this will not add to the problem as there could be upwards of 30 sub reports and this will increase as more clients use the software.

 

[dhookom]

I have experienced data latency issues with chart controls that some time require a Requery of the control during the On Format event of the main report. I wonder if you could add a Me.subrptA.Requery in this event to assure all the records got pulled correctly.

I'm not sure why you need so many different subreports but that is your business rules that are driving them.

Duane
Hook'D on Access
MS Access MVP