Databases Reference
In-Depth Information
10.
This time, choose Report as the region type. Choose the SQL Report type in the
next step, and specify the region title as Employee Listing in the following step.
11.
When you get to the SQL area, specify the SQL shown in Listing 5-9.
Listing 5-9.
Specifying the SQL for the Report Region
SELECT EMPID, EMPNAME, EMPTITLE, EMPDEPARTMENT FROM Employees
12.
Complete the wizard to create the region. Now run the page. You should see
your pie chart and employee list all in the same page, as shown in Figure 5-29.
Figure 5-29.
The dashboard in action
How It Works
Regions are APEX's way of organizing visual information within a single page. Using regions, you can
even mix data entry forms and charts together in the same page. Regions are highly flexible; they can
also be positioned anywhere you wish. In this way, you can create dashboards that convey a mix of
information from different sources in different ways.
