Chapter 13. APEX Reports
Reports are an essential component of any application as they provide a way to query and view data stored in our applications while providing the results in a meaningful format. In APEX, reports are defined using a report region. In the following chapter we will discuss how to build and modify a report region while exploring the reporting features APEX has to offer. Specifically, we shall be looking at:
Creating a simple report using a wizard
Modifying a report manually
Building a parameterized report
Creating charts
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...