Hello! I'm fairly new to Reporting and Report Server so I'm wondering if there are some tips on making a report I'm trying to generate run better. The desired result I'm looking for is to get a report in Excel that can be up to 150,000 lines. If I run the query in SSMS it takes about 2 seconds, but how I have it designed in the Report server it times out after 100(?) seconds. If I limit the range to ~80,000 records it can being it up, but takes about a minute to run and you can tell the browser is under a heavy load.
To create this report, I ran the Table Wizard and little else. I see that creates a table in the Details section of the report, which makes this many rows super tall (which is fine), but I'm wonder if there's a better practice for creating reports which are destined for Excel?
1 Answer, 1 is accepted
Hi Rob,
Generally, a lot of factors will influence the report's performance: machine capabilities, number of report items, amount of data, report's complexity and rendering format. Note that we suggest a minimum of a dual-core processor with at least 2 GB of RAM for the machine where the REST Service is running. Grouping and bindings can also decrease the speed of rendering.
For more information on how the report could be improved, you may check Performance Considerations help article.
Note also that in Excel 97-2003 the maximum number of rows in a worksheet is limited to 65,536. If this is exceeded, the renderer displays an error message. In Excel 2007 and above up to 1 million rows are supported. For more information, you can visit Design Considerations for Excel Rendering article.
Regards,
Neli
Progress Telerik