 Bar Graph [message #378435] |
Tue, 30 December 2008 07:40 |
sweetkhaliq
Messages: 200
Registered: April 2006
|
Senior Member |
|
|
Dear Members
I am working on forms 6i and oracle 9i 9.2.0.1.
I want to make a bar graph based on employee attendance system that show hours on columns and days in row. If employee comes at 9:00 am on day 1. And he go out at 11:50 am then the period he was in the factory that will be shown in blue bar and he comes back at 12:55 pm. The time he was out from the factory should be show in red color. When again go out at 6:00 pm the duration he was in the factory should display in blue bar.
Tell me how to make a graph like this.
Please also tell me how to make the hours in query.
Can this in out of employee be managed in one bar with different colors for one day.
The table structure is like this
Attendance
-----------
emp_code varchar2(6),
atten_date date,
time_in date,
time_out date
Urgent reply will be much appriciated
[Updated on: Tue, 30 December 2008 07:44] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
