Adding a Department Column to the Employees Report

Add a Column

In order to filter the Employees report by department, add a Department column to the report.

To add a column:

1. Click on Edit Page 3 in the Developer toolbar.

2. Under Regions, right-click Employees and select Edit.

   The Region Definition appears.

3. Scroll down to Source.

4. Replace Region Source with the following SQL:

   SELECT e.EMPLOYEE_ID,
       e.FIRST_NAME,
       e.LAST_NAME,
       e.HIRE_DATE,
       e.SALARY,
       e.COMMISSION_PCT,
       calc_remuneration(salary, commission_pct) REMUNERATION,
       e.DEPARTMENT_ID,
       d.DEPARTMENT_NAME
   FROM OEHR_EMPLOYEES e,
       OEHR_DEPARTMENTS d
   WHERE e.DEPARTMENT_ID=d.DEPARTMENT_ID
   

5. Click Apply Changes.

6. Click Apply Changes to confirm.

   The next section explains how to add the column to the report display and how to use this column to filter employee reports.

Display Column in the Report

When you first run this report, use the Select Columns action to add the Department Name column to the display. Once this column is visible on the report, make this report the default and filter by department.

To add the Department Name column to the report:

1. Click the Run Page 3 icon.

2. Click the Actions menu and select Select Columns.

3. Move Department Name from the Do Not Display box to the last entry in the Display in Report box.

   
   Description of the illustration bldap_deptcol.gif
   
   

4. Click Apply.

   The Employees Report is displayed and includes the Department Name column.

   
   Description of the illustration bldap_empdept.gif
   
   

   Next, make these report settings the default.

Save Report Settings as the Default

This section describes how to save the current report settings as the Primary Default report. Report settings are any setting made through the Actions menu including: selected columns, filters, sorting, rows per page, format setting such as sort control breaks, highlighting, and so on, and flashback.

Both developers and end users can save interactive reports. However, only a developer can save the report that initially displays, called the Primary Default report.

Once the default settings are saved, these columns are the default display in this report.

To save the current report settings as the default:

1. Run the Employees report page.

   The current report default does not include the Department Name column when the report is displayed.

2. Click the Actions menu.

3. Select Save Report.

4. For Save, select As Default Report Settings from the list.

5. Accept the Default Report Type setting, Primary, and click Apply.

   
   

   Note: If a reset is performed on this page, these default report settings are used. The Department Name column is displayed by default.