A script-enabled browser is required for this page to function properly.

Maximum Rows to Fetch property

The Maximum Rows to Fetch property specifies the maximum number of rows of data that the query should retrieve. Reports Builder will only retrieve the number of rows for the query that you specify in this property. When you are designing a report, you often must run it many times to see how it looks. If your report retrieves a lot of data, this can be very time consuming. This property can improve performance by reducing the amount of data retrieved and formatted.

Applies to

Queries

Values

A whole number from 1 through 32K means that only that number of rows will be retrieved . If left blank, all rows are retrieved.

To restrict the rows retrieved by some, but not all, of a query's groups, use the Filter Type property in the Group properties. 

Default

Blank

Required/Optional

Optional 

PL/SQL procedure

SRW.SET_MAXROW

Usage notes