Home » Developer & Programmer » Reports & Discoverer » Bar Graph (Reports 6i and oracle 9i 9.2.0.1)
icon9.gif  Bar Graph [message #378435] Tue, 30 December 2008 07:40
sweetkhaliq
Messages: 189
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

Previous Topic: different repeating frame with same alignment
Next Topic: System Hangs during report generation
Goto Forum:
  


Current Time: Sat Dec 10 22:22:52 CST 2016

Total time taken to generate the page: 0.08808 seconds