Hi, there are two options to use a report for me: generate pdf (by using rs:Command=Render&rs:Format=pdf) in url or access report through reportviewer control (user sees interactive report where he can filter stuff and all). So, my question is this: when user accesses pdf and when he does some action through interactive report - in both cases he issues a request to report server, but is there a difference in load on server? Thanks

In nearly all cases I've observed, the PDF renderer is slower than others. It runs a lot of code to transalate the internal intermediate rendering format into th final output. The product team has perfected HTML and wrote much of the product around it. I understand that rendering to PDF is quite a bit more difficult to do.Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com *Please vote if helpful*

Hi Ren, By default, the fastest and least memory intensive formats include CSV, XML, and HTML. PDF and Excel have the slowest performance (http://technet.microsoft.com/en-us/library/ms159638(SQL.100).aspx), 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. The above is in reference with Albert Ye link http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/ca45fcc4-be69-410f-aaed-19b65f279330 Regards, PS Regards, PS