Changing the Column Format

Next, change the format of the columns that contain numeric values.

To change the column format:

1. Click Edit Page 3 on the Developer toolbar (at the bottom of the page).

   The Page Definition appears.

2. Under Regions, click Report.

   The Report Attributes page appears.

3. Locate the Column Attributes section.

   Next, change the column and heading alignment for the appropriate columns.

4. For Column Alignment, select right for SALARY, COMMISSION_PCT, and REMUNERATION.

5. For Heading Alignment, select center for SALARY, COMMISSION_PCT, and REMUNERATION.

   Next, edit the format of the value in the column.

6. To edit the format of SALARY:

   1. Under Column Attributes, click the Edit icon next to SALARY.

      
      Description of the illustration edit_icon_col.gif
      
      

      The Column Attributes page appears.

   2. For Number/Date Format, select $5,234.10 from the list.

      Notice that the appropriate format mask appears in the field.

   3. Click Apply Changes.

7. Repeat the previous step for REMUNERATION.

8. Click the Run Page icon in the upper right corner to preview the page.

   Notice that the numbers in the Salary and Remuneration columns now appear with the dollar sign, include commas and decimals, and are correctly aligned.

   
   Description of the illustration bldap_emprptnum2.gif