I have a report that is fairly complecated, the report is based off of a Cross Tab Query, and has 3 subreports on the report with their information based off of a Cross Tab Query. Normally this report works fine when 1 - 3 pages is the length. The users then tried to run this report with criteria that equaled 18 pages of information. The report previewed the first and second page just fine, but when you try to go to the third page in print preview, the error "System Resource Exceeded" pops up with an OK button. Once the OK button is pressed, then the report closes.
I have removed the subreports, and if I remove the only subreport that is linked to each record (and leave the subreports that only show Totals information at the bottom), then all 18 pages will preview correctly.
I am just curious if anyone has run into this problem before.
Thank you for you time,
T.J.
I have removed the subreports, and if I remove the only subreport that is linked to each record (and leave the subreports that only show Totals information at the bottom), then all 18 pages will preview correctly.
I am just curious if anyone has run into this problem before.
Thank you for you time,
T.J.
