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.