Re: Gantt style charts!

Brian W. Chester wrote:
>
> Hi, and best of the season,
>
> I am working on a project which requires a special gantt style display be
> designed. This display must be able to display a specific number of days
> worth of data at a time and show a specific number of rows. The user must
> 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
> Nov 15, 2000 and the display is designed to show 25 rows and 45 days at one
> time, the user should be able to use a scroll bar to move down the list of
> 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
> 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
> can be produced within Graphics, but can not find a way to display either a
> 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,
> I have been unable to produce the chart with scroll bars.
>
> Additionally, the gantt chart must display multiple date grouping for the
> same event_id on the same displayed row. The gantt chart in graphics does
> this relatively well but as mentioned the way it is scaled and the lack of
> scroll
> bars prohibits its use
>
> One last requirement of this form is that the user wants to be able to use
> 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
> the duplication if you were able to find the first posting. My news server
> has not received it!

[Quoted] A possible workaround in Graphics is to scale the graph to a size significantly larger than the its containing window and use the standard window scroll bars (or scrolling canvas) to allow 'scrollability'

HTH

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."