Report regions
As described earlier, regions are a container for content on an APEX page. A report region is used in APEX to display the results of a SQL Query in a formatted HTML table within a page. A page can contain multiple report regions and also co-exist with other region types, such as a chart or a form. Report regions offer many built-in functions that will be covered later in this chapter, such as column sorting, record pagination, templates, and printing.
As is common to most areas of APEX, a wizard is provided to help guide us through the creation of a report. The wizard ensures that we can rapidly add reporting functionality to our pages with minimal work. In APEX, the report region wizard provides four types of reports that we can add to a page, and they are:
SQL report: This is where the report is based on a SQL query or a PL/SQL function that dynamically generates a SQL statement. A SQL query selects the columns we wish to display, together with the tables where the data...
