| How-To Document
Customize Report Pagination
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 and pagination.Prerequisites
Using different report pagination styles
The HTML DB engine can paginate result sets of a report region in a variety of ways as figure 1 illustrates.
Steps to modify report pagination:
Implementing a custom pagination style using report templates
If the build-in pagination styles do not meet the requirements of a particular application, you can implement a custom build pagination style by defining a pagination sub-template as part of your report template. In the following example we will define HTML based buttons to control navigating to the previous and next page of a report. The UI theme used in this example is the Opal theme, which is part of the HTML DB sample application. The sample application is installed as the default application when creating new workspaces.
Discuss this how-to in the OTN HTML DB Discussion Forum.