In Oracle HTML DB a report is simply the formatted result of a SQL query. You can generate reports by:

• Selecting and running a built-in wizard
• 
  
• Defining a report region based on a SQL query
• 
  
• Defining a report region based on a PL/SQL function returning a SQL query
• 
  

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.

• Oracle HTML DB
• 
  

The HTML DB engine can paginate result sets of a report region in a variety of ways as figure 1 illustrates.

• Page result sets (that is "Internet style" pagination)
• Row ranges paginated by set (for example, Row(s) 1-10, 11-20, and 21-23)
• Row ranges in a self submitted select list (paginated by page)
• Row ranges paginated by page (for example, 1 - 10 of 23)
• 
  
  
  Fig. 1: Pagination Styles
  
  

Steps to modify report pagination:

• Navigate to the report attributes page following the steps below to change the report pagination style:
  
  
  1. On the report attribute page scroll down to the region titled "Layout and Pagination".
  2. Pick a pagination scheme from the drop down select list titled "Pagination Schemes" or use the quick links below the select list to set the pagination style (see Fig. 4).
  3. Set desired display position for your pagination controls, pagination controls can be shown above or below the report (or both) and can be position left or right aligned.
  4. Click on apply changes to save the changes to your report.
  
  

  

  Fig. 4: Report Attributes, Layout and Pagination

• The following screens demonstrate the most commonly used pagination styles:
• 1. When using the style "Row Ranges with set pagination", a number of row ranges are shown in the form "x-y", the number of rows per range is determined by the "number of rows" attributes, the "next set" and "previous set" links take the user to the next or previous set of row ranges.
  2. 
     

     

     Fig. 5: Pagination Scheme 'Row Ranges 1-15 16-30 (with set pagination)'

  3. Pagination controls can be displayed above and below a report (or both), they can also be aligned left or right. Fig. 6 shows pagination aligned to the right and displayed above and below the report.
  4. 
     

     

     Fig. 6: Pagination Scheme 'Row Ranges 1-15 16-30 (with set pagination)' displayed above and below the report'

  5. When using "Row Ranges in select list" the row ranges can be selected from a drop down select list, they are shown as "x-y of z", the total number of rows is included. The previous and next buttons take the user to a page containing the next or previous range of rows.
  6. 
     

     

     Fig. 7: Pagination Scheme 'Row Ranges 1-15 16-30 in select list (with pagination)'

  7. The style "Search Engine" refers to the way many search engines and online shopping sites display search results. Instead of row ranges, the user can pick the page number to navigate back and forth. The next and previous set links take the user to the next and previous set of pages.
  8. 
     

     

     Fig. 8: Pagination Scheme 'Search Engine 1,2,3,4 (set based pagination)'

  9. "Row Ranges with pagination" differs from the "Row ranges with set pagination" style in that it only displays one row range at a time and clicking on the next and previous buttons takes the user to the next and previous range as opposed to the next and previous set.
  10. 
      

      

      Fig. 9: Pagination Scheme 'Row Ranges X to Y of Z (with pagination)'

  11. The simplified "Row Ranges x-y" style can be used to improve performance. When using this style, the total number of rows is not computed, the previous and next buttons take the user to the previous and next page.
  12. 
      

      

      Fig. 10: Pagination Scheme 'Row Ranges X to Y (with next and previous links)'

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.

• Figure 11 shows a report page using the Opal UI theme. The pagination style is a customized version of the "Row Ranges in Select List" pagination scheme.
• 
  

  

  Fig. 11: Report with custom built pagination style

• To achieve this pagination look, you need to modify your report template or create a new one from scratch. The sample application has a report template define which is called "Opal Alternating Report", other UI themes generally provide an "alternating row colors" report template that can also be used to define pagination sub-templates. Follow the steps below to build your own customized pagination style:
• 1. Navigate to the Application Builder start page, either by clicking the "Application" parent tab or the "Home" link in the navigation bar.
  2. On the Application Builder start screen, click on the "Templates" tab.
  3. Scroll down to report templates and click on one of the provided report templates, in our example we use the template named "Opal Alternating Report".
  4. On the report template definition page, scroll down to "Pagination Subtemplate" (see fig. 12).
  5. Use the following attributes to define your pagination style:
  6. • Pagination template: Define the look for the text portion of the pagination control, this could be row-ranges, a select list, search engine-style page numbers, etc., use the #TEXT# substitution string to indicate where to display the actual pagination text. The actual text is determined by the selected pagination scheme.
     • Next Page and Previous Page: If the selected pagination scheme allows navigating from page to page, you can define the look of the navigation controls here, use images, hyper links, buttons, etc.
     • Next set and Previous Set: If the selected pagination scheme allows navigating from one set of row ranges to the next set, you can define the look of the navigation controls here, use images, hyper links, buttons, etc.
  7. Click on apply changes to save the changes to your report template.
  
  

  

  Fig. 12: Pagination Sub-Template

• To use the report template and the customized pagination style with your report, follow the steps below:
• 1. Navigate to the report attributes page and scroll down to the region titled "Layout and Pagination".
  2. Pick a pagination scheme from the drop down select list titled "Pagination Schemes", in our example we used the "Row Ranges in Select List" scheme.
  3. Pick your report template, templates starting with "default" or "export" are build-in templates, following those template you'll find your own report templates, prefixed with the string "template:", pick the one you modified before.
  4. Click on apply changes to save the changes to your report and run your page.

  

  Fig. 13: Report Attibutes, select report template