Because all post-retrieval processing is performed in the memory of the web browser, an report has a processing limit of approximately 5,000 records or 100 pages of output. The active cache option enables you to send only the first page of report output to the browser and retrieve subsequent pages from a temporary cache on the Reporting Server.
Tip: It is recommended that you set the number of rows retrieved five times greater than the number of lines retrieved per page (as indicated in SET LINES). The minimum number of rows retrieved is 100.