Gantt style charts!

[Quoted] I am working on a project which requires a special gantt style display be [Quoted] designed. This display must be able to display a specific number of days [Quoted] worth of data at a time and show a specific number of rows. The user must [Quoted] able to scroll through the data both by date or by row.

For example if a query returns 100 rows with items between Jan 1, 2000 and [Quoted] Nov 15, 2000 and the display is designed to show 25 rows and 45 days at one [Quoted] time, the user should be able to use a scroll bar to move down the list of [Quoted] rows individualy or by large groups of say 5, 10, or so. Like wise the user should be able to scroll through the dates increasing or decreasing by1, 7 [Quoted] or 14 days at a time.

The main application has been designed using the developer 6 tools and consists of 120 forms, numerous reports and graphics. This is the last "form" to be designed and is proving the hardest. I am looking for any solution which can be called from an Oracle v6.x form, report or graphic which will produce the desired effect. I have tried the gantt chart which [Quoted] can be produced within Graphics, but can not find a way to display either a [Quoted] fixed number of days or a fixed number rows. Graphics scrinks the data to fit "its window" until the data is no longer readable or usable. Likewise, [Quoted] I have been unable to produce the chart with scroll bars.

Additionally, the gantt chart must display multiple date grouping for the [Quoted] same event_id on the same displayed row. The gantt chart in graphics does [Quoted] this relatively well but as mentioned the way it is scaled and the lack of scroll
[Quoted] bars prohibits its use

One last requirement of this form is that the user wants to be able to use [Quoted] the mouse to select a date range for a single given row displayed on the chart
and update the database accordingly. If you have any ideas or recommendations
I would greatly appreciate hearing from you.

The table to be charted has the following fields:

    event_id number(12) (foreign key)

    date_in    date                (The start date of the event)
    date_out    date            (The end date of the event)

Thanks and have a great new year!

Brian W. Chester
(bwchester_at_home.com)

PS. This is a repost as it seems the first was not recieved. Please excuse [Quoted] the duplication if you were able to find the first posting. My news server has not received it! Received on Wed Dec 29 1999 - 19:07:10 CET