| How-To Document
Control Page Sizes in Result Sets
After completing this How-To, you should be able to understand:
In Oracle HTML DB a report is simply the formatted result of a SQL query. You can generate reports by:
The HTML DB Application Builder offers a great deal of flexibility in defining report attributes. Using the Report Attributes page, you can specify the report template, column display sequence, display report headings, column and heading alignments, column formatting, sort order, pagination, number of rows per page and total number of rows.Prerequisites
Setting a fixed number of rows per page and the maximum number of rows for a report.
The number of rows attribute determines how many rows are shown on each page. You can either type in a static value into the "Number of Rows" field or you can use an item to dynamically set the number of rows. The field labeled "Max Row Count" can be used to define the maximum number of rows you want to retrieve from the database. The default value is 500. When defining a higher total number of rows, consider using the simplified pagination style "Row Ranges x-y". For this style the engine does not need to process the entire result set for rendering the pagination controls.
Discuss this how-to in the OTN HTML DB Discussion Forum.