Databases Reference
In-Depth Information
5-5. Visualizing Data on a Calendar
Problem
You want to see data plotted on a calendar. The report you've created to display the employee leave
records is great, but you need to visualize it in a more intuitive manner. You wish to have the records
displayed in a calendar based on the leave date of each individual record.
Note
If you haven't already done so, please execute Listing 5-1 to create the sample data used for this recipe.
Solution
Here are the steps to follow to create a page to view your data on a calendar:
1.
To run the sample in this recipe, you need to first add a new record to the
EmpLeave table. Run the query shown in Listing 5-5 via SQL workshop. Take
note to change the date of the
LEAVEDATE
in this query to reflect the current
month and year.
Listing 5-5.
Inserting an Additional Sample Record
INSERT INTO EMPLEAVE(EMPID,LEAVEDATE,LEAVETYPE,LEAVEREASON,LEAVEID)
VALUES('E1',TO_DATE('20110110', 'YYYYMMDD'),'Maternity Leave','Maternity','L4')
2.
Open an application and choose to create a new page.
3.
Choose the Calendar page type in the first page of the wizard, as shown in
Figure 5-18.
