This course explores the various types of reports available in Oracle APEX and shows you how to create and view them.
Learning Objectives
- Understand the different types of reports in Oracle APEX
- Learn the different ways to create reports
- Learn about interactive reports, classic reports, and cards
Intended Audience
- Anyone who wants to enhance their knowledge of Oracle APEX
Prerequisites
We recommend that you take this course as part of our Oracle APEX: Foundations learning path.
Welcome to the Oracle APEX Foundations course. Today, in this lesson on developing reports, I will be talking about the different types of reports in APEX. My name is Apoorva, and I am a Senior Product Manager for Oracle APEX. Let's get started. First, we will see the different types of reports available in APEX. Next, we will see the different ways of creating these reports. Finally, we will discuss interactive reports and interactive grids in detail. A report in Oracle APEX is the formatted result of a SQL query. You can generate the SQL query by selecting a table or a view in a wizard or by defining the SQL query manually. Let us look at a few report types: interactive report, report with a form, cards, and smart filters. The main difference between these report types is the extent and way in which end users can customize the appearance of the data through searching, filtering, sorting, column selection, highlighting, and other data manipulations. You'll learn more about these report types in this lesson. There are different ways of creating reports in APEX. You can create a report when you create a new database application.
You can create a report as a new page in an application, or you can create a report region on an existing page in an application. App Builder includes built-in wizards that enable you to generate reports. Let's take a closer look. When you use the Create Application Wizard and add a report page, supported reports includes Cards, Faceted Search, Smart Filters, Interactive Grid, Interactive Report, Classic Report, and Multiple Reports. When you create a report using the Create Page Wizard, supported reports include Cards, Faceted Search, Smart Filters, Interactive Grid, Interactive Report, Master Detail, and Classic Report. Using this Wizard, you can create a wide variety of reports on a local database or on an external data source. To create a report as a region on an existing page in an application, you open the page definition in the Page Designer. Then you create a report region by using any of the following options. Drag and drop a report region from the gallery. Use the context menu under the Rendering tab. Click the 'Rendering tab' on the left pane and then right click 'Body' and select 'Create Region.'
Use the context menu in the gallery. Right click a 'Report Region.' From the Add To option, select the location where you want to add the report region on the page. This adds the report region to your layout and you can start editing the region. Now that you know how to create a report, let's take a closer look at interactive report. What is an interactive report? An interactive report is a formatted result of a SQL query. End users can customize the report layout and data by selecting options on the Actions menu. Remember, interactive reports are only supported for desktop applications. On the screen, you can see an interactive report built on a sample table called Projects. When viewing an interactive report, end users can customize how and what data displays. By default, interactive reports include a search bar, an Actions menu, column heading menus, and an edit icon in the first column of each row. Using options in the Actions menu, users can alter the report layout by hiding or exposing specific columns and applying filters, highlighting, defining control breaks.
They can also define sorting, aggregations, add their own computations, and create charts. They can also group rows using Group By. Once customized, the report can be saved as either a private report or a public report. What is an interactive grid? An interactive grid presents users with a set of data in a searchable and customizable report. Functionally, an interactive grid includes most customization capabilities available in interactive reports, plus the ability to rearrange the report interactively using the mouse and keyboard. Here, you see an example of an interactive grid built on the Projects table. Users can use the column heading menus to sort individual columns, freeze, and create control breaks. Users can also directly customize the appearance of an interactive grid. Users can use the mouse and the keyboard to resize the width of the column and drag and drop columns into different places in the grid.
Once customized, the report can be saved as either a private report or a public report. To summarize, you learned the different types of reports in APEX and the different ways of creating these reports. We also covered interactive reports and interactive grids. I hope you learned something useful. Thank you for watching.

Oracle University, the learning and training arm of Oracle, is a leader in cloud education, providing modern digital training, certification, and learning solutions across Oracle’s entire product portfolio that enable our customers to master their Oracle Cloud solutions and maximize their investments. Over 2 million certified professionals worldwide have placed their trust Oracle University to reach their learning goals. Learn about Oracle University.