My Oracle Support Banner

Apex Classic Report Fails To Display Subtotal If The Last Row Of A Group Is Also The Last Row Of A Page (Doc ID 2805158.1)

Last updated on SEPTEMBER 13, 2021

Applies to:

Autonomous Database on Shared Infrastructure - Version N/A and later
Oracle Application Express (APEX) - Version 20.1 and later
APEX Application Development - Version NA and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
NOTE: In the images and examples below and the attached documents, user/objects details represent a fictitious sample (based upon made up data used in the Oracle Demos). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


While trying to display the report columns in a Classic report with the sum getting displayed as group by a column the sum is not appearing in some instances based on the number of rows attribute of the Report.

Customer built a report on emp table using the following query.

In the report attribute following are set
- Break Columns = First Column
- Break Column Style = Default Break Formatting

- dummy column DEPARTMENT as non-displayed

In the column attribute for sal set:
- Compute Sum = Yes

The table contains 11 records and when the number of rows attribute is set as default 15, the sum is appearing for each department. But when the rows are set to 6, the sum of the records for Department 20 is not appearing.


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

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

In this Document

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