This course explores the various types of reports available in Oracle APEX and shows you how to create and view them.
- Understand the different types of reports in Oracle APEX
- Learn the different ways to create reports
- Learn about interactive reports, classic reports, and cards
- Anyone who wants to enhance their knowledge of Oracle APEX
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 classic reports and cards. Lets get started. Besides the commonly used interactive reports, there are classic reports and reports built on forms. Cards are another way to view information, and in this lesson, we will take a look at these report types.
A classic report is the formatted result of a SQL query. The screen shows an example of a classic report built on the projects table. Developers can choose a table on which to build a report or provide a custom SQL select statement or a PLSQL function returning a SQL SELECT statement. Apart from sorting and simple filtering, end users cannot customize a classic report. However, developers can control how a classic report works by editing the following attributes in the page designer, the region attributes, the column attributes, and the report attributes. The example on the screen shows a report and a form created on a table. On the Report page, each row provides an Edit icon to the second page that is the form to enable users to update each record.
Report with form creates a report that is an interactive grid, an interactive report, or a classic report and a form on a table or by providing a SQL query. You can use the Create Application Wizard or the Create Page Wizard to create a report and a form combination. The main difference between these two Wizards is that the Create Page Wizard offers additional customization and data source options. Using the Create Page Wizard, you select a report type that is either an Interactive Grid, Interactive Report, or a Classic Report. So, here I go ahead and select an interactive report. It provides the different data source options. That is, the local database, REST enabled SQL Service, or the REST data source. Additionally, you can also specify whether to include and configure Breadcrumb and navigation. A Cards page features colorful blocks which resemble index cards laid out on a page. Each card can display a variety of information pulled from columns in the underlying table. The screen shows an example of a Cards page built on the Projects table.
A cards report region declaratively supports customizations of the layout and appearance and the inclusions of icons, badges, media, and actions. Use cards to embed and share media source from a BLOB column, URL, or a video in an Iframe. Both the Create Application Wizard and the Create Page Wizard support the creation of cards pages. First, you enter a name for the cards page and you select a table or a view or provide a SQL query on which you build the page. Here, I select the Projects table and click 'Next'. Then you specify the general page layout, for example, grid, float, or horizontal row. Finally, you specify the title column, the body column, and optionally, the icon initials column and the batch column, and click on 'Create page.' To summarize, in this lesson, you learned about classic reports, forms, and cards. 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.