Re: Gantt style charts!

Connor,

Thank you for your reply. :)

I have tried extending the graphics display to its maximum possible size of 2 landscape letter pages wide by 2 pages high. While this allows about 6 months and 120 rows, of readable data, any greater amount becomes unreadable again. In addition, using the Oracle Graphics Gantt chart, does not allow a date range to be returned for a specific row. The use wants to be able to use the mouse to highlight a range on the chart.

I have just about given up on another idea to accomplish this which was to use the technique employed in the calendar example supplied with Developer 6. The unfortunate problem with this approach, was the shear number of elements that had to be added. I was only able to create a 15 X 31 grid with the addition of two title columns (One for the actual event number and one for the event type) and 4 additional rows, one for the day of week, one for the day of the month, one for the month and finally one for the year (actually only 3 fields). While scroll bars were unavailable I did manage to mimick them by adding buttons at the top and bottom of the right side and at each side (along the bottom). Alas, the complexity of the array and cursors makes the form too slow and the user has rejected it!

Please, any thoughts are appreciated!

Thanks again.

Brian

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:386B2E68.4414_at_yahoo.com...
> 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!
>
> 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."
Received on Thu Dec 30 1999 - 20:32:37 CET