Adding an Employees Report and Form

In this exercise, you add a report to display employee information and a form to create, update, and delete employee information.

To add an employee report and form:

Click the Application link on the Developer toolbar (at the bottom of the page).

The Application home page appears.
Click Create Page.
For Page:
1. Select Form and click Next.
2. Select Form on a Table with Report.
  
  This option creates two pages, a report and form, based on a single table or view.
3. Click Next.
For Identify Table or View:
1. For Table/View Owner, accept the default and click Next. This specifies the schema owner.
2. For Table/View Name, select OEHR_EMPLOYEES and click Next.
For Define Report Page, make these changes:
1. Implementation - Select Classic.
2. Page Name - Change to Employees.
3. Region Title - Change to Employees.
4. Breadcrumb - Select Breadcrumb.
  
  The Create Breadcrumb Entry section appears.
5. For Select Parent Entry, click the Home link.
  
  Home appears in the Parent Entry field.
6. Click Next.
For Define Report Page, accept the default, Do not use tabs, and click Next.
For Define Report Page, press the Ctrl key, select the following columns, and click Next:
- EMPLOYEE_ID
- FIRST_NAME
- LAST_NAME
- HIRE_DATE
- SALARY
- COMMISSION_PCT
The columns you selected appear on the Report page.
For Define Report Page, accept the defaults and click Next.

Note that the default Edit Link image resembles a small piece of paper and pencil.

Next, define the page and region information for the form.
For Define Form Page, edit the following:
1. Page Name - Enter Create/Edit Employee.
2. Region Title - Enter Create/Edit Employee.
3. Entry Name - Enter Create/Edit Employee.
4. Click Next.
In Primary Key, accept the defaults and click Next.
In Define the source for the primary key columns, accept the default, Existing trigger, and click Next.

Your table, OEHR_EMPLOYEES, already has a trigger that populates the primary key.
In Select Column(s), select all columns and click Next.

These columns now appear in the Create/Edit Employee form.
In Identify Process Options, accept the defaults and click Next.

These selections enable users to add, update, and create employee records.
For Confirm, verify the information and click Finish.

Previewing the Pages

To preview the two pages you just created, run the current page. From the Employees report, you can then preview the form.

To preview the pages:

Click the Run Page icon.

Description of the illustration runpg_afterwiz.gif

The Employees report appears.

Description of the illustration bldap_empform.gif

Note the following about the Employees report:
- The Edit icon you selected appears in each row. You can click the Edit icon to update the employee record.
- The Create button appears in the upper right corner. You can click the Create button to add an employee to the underlying table.
- The Employees report includes the five columns you specified. When you selected the columns and applied the changes, Oracle Application Express created the appropriate SQL code in the background to produce this result.
Your data might appear in a different order. If so, ignore this difference and continue with these steps.
To review the form you also created, click the Edit icon in an Employee row.

The Create/Edit Employee form appears.

Description of the illustration bldap_empeditfrm.gif

Note the following about the Create/Edit Employee form:
- The form includes Cancel, Delete, and Apply Changes buttons.
- The Hire Date field displays a calender, which is included because the data type of the underlying column is DATE.