Controlling Report Pagination

You control report pagination by:

Including a pagination substitution string in the report template
Making selections from the Layout and Pagination section on the Report Attributes page

You control how pagination displays by making selections from the Layout and Pagination attributes on the Report Attributes page.

Topics:

Accessing and Understanding Layout and Pagination Attributes
Including Pagination After the Rows in a Report
Including Pagination Before the Rows in a Report

Accessing and Understanding Layout and Pagination Attributes

To access the Layout and Pagination section of the Report Attributes page:

Create a report. See "Creating a Report Using a Wizard".
Navigate to the appropriate Page Definition. See "Accessing a Page Definition".
Under Regions, click the appropriate Report attributes link.

The Report Attributes page appears.
Scroll down to Layout and Pagination.

You use the Layout and Pagination attributes to select a pagination style, determine where pagination occurs, and specify the number of rows that display on each page. Table: Layout and Pagination Attributes describes the most commonly used Layout and Pagination attributes.

To learn more about a specific attribute, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

Layout and Pagination Attributes

Attribute	Description
Report Template	Specifies a template to be applied to this report. Report templates provide control over the results of a row from your SQL query. You can choose from a number of default templates, or pick a custom build template.
Show Null Values as	Enter the text you want to display for null columns. The default value is `(null)`.
Pagination Scheme	Specifies a pagination scheme for this report. Pagination provides the user with information about the number of rows and the current position within the result set. Pagination also defines the style of links or buttons used to navigate to the next or previous page. For more information, see the Help information for this attribute.
Display Position	Defines where pagination occurs. If you choose to display pagination above a report, the selected report template needs to support that type of display.
Number of Rows	Defines the maximum number of rows to display on each page.
Number of Rows (Item)	Defines the number of rows displayed by default per page for SQL queries (obtained dynamically from an item). Identify the item in this attribute.
Maximum Row Count	Defines the maximum number of rows to query, for example, rows 1 - 10 or 456. If you set this attribute to 200, the result would appear as follows: `rows 1 - 10 of more than 200 rows` Note that this attribute impacts performance. Counting fewer rows can improve performance and counting thousands of rows can degrade performance.
Strip HTML	Specify whether or not to remove HTML tags from the original column values for HTML expressions, column links and report data exported as CSV files. If you select values from the database that already contain HTML tags, then those tags can cause conflicts with the HTML generated for your columns links or HTML expressions. When this option is enabled, only the actual data portion of your column value is used.
Sort Nulls	For reports with column heading sorting, specify if you want null valued columns to sort first or last. See Also: "Enabling Column Sorting"

Including Pagination After the Rows in a Report

To include pagination after the rows in a report:

Create a report. See "Creating a Report Using a Wizard".

Next, select the appropriate Layout and Pagination attributes.
Navigate to the Report Attributes page:
1. Navigate to the Page Definition. See "Accessing a Page Definition".
2. Under Regions, click the appropriate Report attributes link.
  
  The Report Attributes page appears.
Under Layout and Pagination, select the following:
1. Report Template - Select a report template (optional).
2. Pagination Scheme - Select a pagination scheme.
3. Display Position - Select a display position.
4. Number of Rows - Specify how many rows display on each page.
5. Click Apply Changes.
Edit the report template:
1. Navigate to the Page Definition. See "Accessing a Page Definition".
2. Under Templates, select the report template name.
3. Include the #PAGINATION# substitution string in the After Rows attribute.
4. Click Apply Changes.
Run the page.

Including Pagination Before the Rows in a Report

To include pagination before the rows in a report:

Create a report. See "Creating a Report Using a Wizard".

Next, select the appropriate Layout and Pagination attributes.
Navigate to the Report Attributes page:
1. Navigate to the Page Definition. See "Accessing a Page Definition"
2. Under Regions, click the appropriate Report attributes link.
  
  The Report Attributes page appears.
Under Layout and Pagination:
1. Report Template - Select a report template (optional).
2. Pagination Scheme - Select a pagination scheme.
3. Display Position - Select a position that contains the word top.
4. Number of Rows - Specify how many rows display on each page.
5. Click Apply Changes.
Edit the report template.
1. Navigate to the Page Definition. See "Accessing a Page Definition".
2. Under Templates, select the report template name.
3. Include the #TOP_PAGINATION# substitution string in the Before Rows attribute.
4. Click Apply Changes.
Run the page.