My Oracle Support Banner

How to Print the Report Total Pages only on the Last Page? (Doc ID 130432.1)

Last updated on APRIL 11, 2024

Applies to:

Oracle Reports Developer - Version 6.0.8 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Microsoft Windows (32-bit)

Purpose

This document will show how to print report total pages only on last page.

It gives a workaround to get the report total pages number and use it, in the format trigger of a field so that will be printed ONLY at the last page of the report.

The problem is that you cannot refer to a field with source total_pages in the format trigger of another field without getting the error 'REP-730 The following bind variable is not defined', and also there is not any build in function (like srw.get_page_num) to calculate the report total pages.

Scope

Developers

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.