Modify The Employee Report

In this topic, you modify the Employee Report by and changing query to show the name of the manager instead of the Manager ID, and changing the format of the SALARY column.


To edit the page, click the 1-Employees page icon.




The first time you edit the page, you receive a popup with an explanation of the tree view. Click OK.




Under Regions, double-click the EMPLOYEES Interactive Report.




To see the SQL Query this report is based on, click the Source subtab.




You want to change the SQL query so that the MANAGER_ID shows the last name of the manager instead of the ID.




Replace MANAGER_ID with the following and click Apply Changes.


(select e.LAST_NAME from EMPLOYEES e where e.EMPLOYEE_ID = EMPLOYEES.MANAGER_ID) Manager,



Click Apply Changes to confirm your change.




You want to change the format for SALARY. Double-click the EMPLOYEES Interactive Report again.




Click the Report Attributes tab.




Select the edit icon in front of the SALARY Column Attribute.




Select the List of Values icon for Number/Date Format.




Select the $5,234.10 link.




Click Apply Changes.




In the upper right corner, click the Run Page icon.




Because you changed the SQL query, the new column Manager is not displayed by default. Select the Actions pulldown.




Select Select Columns.




Select Manager from the Do Not Display list and click the Move icon to move it to the Display in Report list.




Select the Manager column and click the Up icon until the column appears under Hire Date.




You do not want to show the Employee Id. Select it from the list and click the Remove icon to move it to the Do Not Display list.




Click Apply.




Notice the Manager is changed to the Last name of the Manager for each employee and the format of the Salary column has changed.




To save the changes you just made, you need save the report. Select Actions > Save Report.




Select As Default Report Settings from the Save pull down.




Click Apply. In the next topic, you create a calendar page for Projects. Select the Application button in the Developer Toolbar.