The following steps explains how to enable Incremental Fetch for Report Services document.
- Open the document in the Document Editor.
- If the document contains multiple layouts, select the layout to apply incremental fetch to.
- From the Format menu, choose Document Properties. The Document Properties dialog box opens. (As shown below)
- Select Incremental Fetch.
- Select the Enable Incremental Fetch check box.
- From the Fetch Level drop-down list, select the object to be counted for the incremental fetch level.
- If the document or layout is grouped, the groups are displayed in the drop-down list. Groups that are displayed as single element only are not shown on this list. If the document or layout is not grouped or all the groups are displayed as single elements only, the only option is the Detail section.
- Enter the Block Size, which is the number of objects (of the Fetch Level) that are returned in each block.
- Click OK to return to the document.
