2000-page limitation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dean Slindee - 04 Jul 2008 19:32 GMT

Other than the seconds time limitation, is there any other Reporting
Services setting that would limit a Reporting Services report run to 2000
pages? We have an annual tax bill report that needs to print 6000 pages in
a single run. However, it is stopping after 2000 pages by itself. Looking
for the reason for the 2000-page limit.

Thanks in advance.
Dean Slindee

Reply to this Message

Parker - 06 Jul 2008 15:18 GMT

If it is exactly 2000 pages, I would suggest seeing if there is some
limitation on the printer side of things.

As a workaround, If you can revise the report to print in 1000 page
'chunks', that may see you through. If the report is sorted by some
known value (like names or tax numbers) that would be a basis for
either adding parameters to the existing query or creating a new set
of queries for the report.

Final thought - if you are rendering to PDF, try to set as many
objects as possible to have 'CanGrow' and 'CanShrink' set to false -
this speeds up the rendering and takes less memory.

Reply to this Message