5.3. Report Creation

Your data schema is set and populated. You have pages in place to look at small amounts of data, such as a list of customers or the order items in a particular order. But the value of data expands as you create reports on larger amounts of information. Reports give your users the ability to move from a view of a single entity, such as an order, to a larger universe, such as overall sales.

You unlock this value through the use of reports and charts, and APEX gives you some very nice options to easily deliver that increased value.

Try It Out: Creating a Standard Report

You have already created reports as part of the page creation process. It's time for you to design some reports that provide a wider view of data by accessing more than two tables.

The first report you will create is a standard APEX report.

  1. Return to the APEX development environment, and click Create Page.

  2. Select the Report choice, and click Next.

You can use a Report Creation Wizard to create a report quickly.

  1. Select the Wizard Report, and click Next, which will bring up the page shown in Figure 5-10.

  2. Change the Page Title to Orders Report and the Region Title to Orders. Click Next.

  3. On the next page, accept the default, Do not use tabs, and click Next.

The next page, shown in its complete state in Figure 5-11, is the core page in the wizard. In this page, you can select one or more tables to use in your report.

  1. Select the ORDERS table in the Table/View selection list. This action will cause the ...

Get Beginning Oracle® Application Express now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.