Hello everybody, i having a bit of a problem here with the PDF rendering performance on reporting services, i made a few tests and this is my result TYPE TimeRendering (ms) Sec excel 18121 18,121 PDF 103895 103,895 RTL 4704 4,704 CSV 5042 5,042 This are all times for the same report with same amount of data retrieved just changing the export format, i have already increased the machine memory where the reporting services is running, because sometimes was reaching the limit, but still no improvement on PDF RENDER. what can i do to speed this up, the data retreived by the reports is fast changing so cache is not an option, can you shed some light here thank you in advance

Hi Ricardo, By default, the fastest and least memory intensive formats include CSV, XML, and HTML. PDF and Excel have the slowest performance, but for different reasons, PDF is CPU-intensive, while Excel is RAM-intensive. To improvement PDF render performance, you can refer to the document: http://msdn.microsoft.com/en-us/library/dd353300(v=sql.90).aspx 1. Avoid horizontal page breaks. To remove extra horizontal pages, review the margins, column widths, and white space in a report. The report processor preserves the white space that you see on the report design surface. To verify your changes, export the report to a TIFF file and view it in the Microsoft Windows Picture and Fax viewer. 2. Avoid including a reference to the built-in field TotalPages in the page header or page footer. Renderers that display reports on physical pages must process a report with this value twice: once to determine the total number of pages, and a second time to render each page with the correct value. 3. Where possible, avoid setting the report item property RepeatWith to True for reports that span multiple horizontal pages. 4. Verify that the page size is set to a reasonable value, for example, 8.5 in. Thanks, Albert Ye