Complex Report Printing

[sailorric]

I have a complexed report with many subreports. The output is generally over 100 pages. The report prints pages with no data after about 50 The information is in the source queries but does not make it to the report. Can anyone help?

 

[smedvid]

Is the query a snapshot? I've generated reports of equal or greater length without a problem... Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[sailorric]

The report is based off of queries and is run inside of an .mdb. I have also run larger but not as complexed reports. Does Access cut off the report once the amount of data is to large. I have run the report on one half gig machines with same results.

 

[smedvid]

Not knowing the full extent of complexity involved with the sub-reports... I would recomend rebuilding the report without any sub-reports (pure data dump). This will verify that there are no data issues or Access size limits. Next, add in each sub-report and test. My opinion is that there is an error buried in one of the sub-reports. Perhaps a linking logic error.

Or possibily a corrupt report/database. Try Repair/Compact also..

htwh, Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...