Beginning Oracle® Application Express

5.4. Report Manipulation

The interactive report you have just created with a few pages of specifying attributes can change in many ways. This section will go through many of the ways your users can shape their interactive reports.

1. Click the Run Page icon to run the interactive report you just created. The report will initially look like Figure 5-17.

You have already seen, and played with, an interactive report in an earlier chapter. You can now poke around and explore much more of the functionality inherent in these reports. In the following steps, you will look at most of the choices available to you on the Action menu for the interactive report. Your first task is to revisit the choices available through the column headings and to change the formatting of your currency fields.

1. Make sure that the Edit Links are showing for the report page, and click on the column heading List Price to bring up the menu shown in Figure 5-18.

   Figure 5-17. Figure 5-17

   

   Figure 5-18. Figure 5-18

   

2. Click on the yellow arrow on the far right of the icons to edit the properties of the report.

3. Select the LIST_PRICE edit icon in the attribute page and change the Number/Date Format to represent currency formatting.

4. Click Apply Changes, and take the same actions for the UNIT_PRICE column. Once you have finished, ...