Prev: How to Create SQL 2005 Reports with Parameters
Next: Installing SSRS over another server within the same domain
From: Dean Slindee on 4 Jul 2008 14:32
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

From: Parker on 6 Jul 2008 10:18
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.
 | 
Pages: 1
Prev: How to Create SQL 2005 Reports with Parameters
Next: Installing SSRS over another server within the same domain