O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing group reports

In group reports, data is grouped and shown as subtotals, and is then aggregated to show a grand total. These reports can be implemented in APEX in the following ways:

  • Using the Break Formatting section in classic reports
  • Using grouping sets
  • Using interactive reports. We will see this method in the next chapter.

Using the Break Formatting section in classic reports

In this section, we will see a report which groups the data based on the PRODUCT_NAME column and has a grand total of all employees at the end.

In the Report Attributes page of any classic report, checking the Sum checkbox (highlighted in the following screenshot) of any column of the report which has numeric data and putting No Breaks in the Break Columns dropdown ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required