size is determined by the row set that

size is determined by the row set that comes back from the query. To estimate the size of a report after it is processed, review the row count returned from the query. If it is many thousands or hundreds of thousands of rows, I provide you with some recommendations in the list that follows. For reports that contain volatile data, report size can change dramatically from one report run to the next. Be sure to monitor the data source to determine how data volatility affects your report and whether you need to follow the steps I prescribe for large reports. Here are some general recommendations when you re considering how to configure and run large reports: Design the report to support pagination. The report server sends a report one page at a time. If the report includes pagination, you can control how much data is streamed to the browser. Configure the report to run as a report execution snapshot. Use this option if you can t add page breaks. Do not set a time-out value for report execution. Use a schedule to determine when the report data is refreshed. Never run a large report on demand because it almost never succeeds. Configuring a report to run as a report execution snapshot prevents it from running on demand. The HTML rendering format used to initially render a report opens the report in a browser, and most browsers cannot accommodate very large documents. For example, a report that contains 5,000 rows of data almost certainly cannot be viewed in a browser in a single page. Consider distributing a report as a file share on a file directory. If the report is very large, it will hang the browser when a user opens the report in Report Manager. Configure the report to use a shared data source if you want flexibility in determining whether the report is processed. One advantage to using a shared data source is that you can disable it so that it cannot be used to get data for the report. Disabling the data source prevents report processing. Use stored credentials for the data source connection for security and to enable data-driven subscriptions for the report. Disable report history (optional) if you want to conserve disk space. The recommendations for report distribution offered later in this chapter (see the Distributing reports section) provide an alternative to storing a large report in report history. To disable report history, clear all the check boxes on the History properties page. Configure the report to use item-level security. Limit access to users who define the subscription and manage the report. Chapter 14: Optimizing Report Performance 267

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Clan Web Hosting services

Bookmark the permalink.

Comments are closed.