4.8.7 Limiting the Number of Rows in a Table

There are several ways to limit the number of rows (records) presented in a table:

To limit the number of rows retrieved and displayed by a particular table in Live Preview mode only, set the 'Max Display Rows' property in the table 'Table Properties' dialog box.

To limit the number of rows retrieved from the database at runtime (and displayed in Preview and Live Preview modes), set the 'Max Rows' property in the table 'Table Properties' dialog box.

To globally limit the number of rows returned by all queries and sub-queries, set the 'Design mode sample data size' in the 'Worksheet Options' dialog box.

To retrieve only the rows of a table matching some specified criteria, set a filtering condition on the table.

To retrieve only the rows of a table that have some specified relationship to the data of another table, create a joined table.

See Tailoring Server Performance in the Administration Reference for other methods of limiting query size and duration.

See Also

Setting Table Query and Display Properties, for details about 'Table Properties'.

Setting Global Worksheet Options, for details on 'Design mode sample data size'.

Tailoring Server Performance, in Administration Reference, for global limits.

Filtering, for information on how to set a filtering condition on a table.

Joining Tables, for limiting rows displayed by comparison with another table.

<< 4.8.6 Showing Live Data in a Table © 1996-2013 InetSoft Technology Corporation (v11.4) 4.8.8 Displaying the Length of a Table >>