Diagram in Forms?

[Norbert Zawodsky]

Hello everybody,

since I played around for quite some time now without any success, I
decided to ask the community...

Is it possible to add a diagram to a (sub)form?

What I need to solve is:

DB has two tables, lets say ItemData (containig ID, Text, Current price,
......) and ItemPriceHistory (containig ID, Date, Price).
I created a Main form linked to "ItemData" and a subform on it linked to
"ItemPriceHistory". When I select an item in main form, I see it's price
history in the sub form.

So far a matter of only a few mouse clicks :-)

Now, I see the price history as a table but would like to see it as a
line diagram. And there I'm stuck...

(I did this in access but dont want to use access....)

many thanks,
Norbert

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Ferry Toth]

Norbert,

i received an example from Ariel Constenla-haile that is now not
available for download anymore. I still have it though, so if you give
your e-mail address I can send it directly to you.

Ferry


Op vrijdag 03-10-2008 om 19:29 uur [tijdzone +0200], schreef Norbert
Zawodsky:

> Hello everybody,
>
> since I played around for quite some time now without any success, I
> decided to ask the community...
>
> Is it possible to add a diagram to a (sub)form?
>
> What I need to solve is:
>
> DB has two tables, lets say ItemData (containig ID, Text, Current price,
> ......) and ItemPriceHistory (containig ID, Date, Price).
> I created a Main form linked to "ItemData" and a subform on it linked to
> "ItemPriceHistory". When I select an item in main form, I see it's price
> history in the sub form.
>
> So far a matter of only a few mouse clicks :-)
>
> Now, I see the price history as a table but would like to see it as a
> line diagram. And there I'm stuck...
>
> (I did this in access but dont want to use access....)
>
> many thanks,
> Norbert

[Frank Schönheit - Sun Microsystems Germany]

Hi Norbert,

> Is it possible to add a diagram to a (sub)form?

No, sadly not. (Not out of the box. Macro magic certainly would allow
you this, though I never dealt with the chart API myself, so I do not
know the details.)

Since Ocke added charts to reports, it wouldn't even be too difficult to
implement, /me thinks, Ocke already implemented most of what's needed.

Are you aware of an issue requesting this feature?

ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Ferry Toth]

Yes, the example contains some macro magic. but to be honest even Access
doesn't allow really usefull graphs without code I think.

Maybe a wizard producing the code would be good, to allow some
customization afterward.

Ferry

Op vrijdag 10-10-2008 om 13:35 uur [tijdzone +0200], schreef Frank
Schönheit - Sun Microsystems Germany:

> Hi Norbert,
>
> > Is it possible to add a diagram to a (sub)form?
>
> No, sadly not. (Not out of the box. Macro magic certainly would allow
> you this, though I never dealt with the chart API myself, so I do not
> know the details.)
>
> Since Ocke added charts to reports, it wouldn't even be too difficult to
> implement, /me thinks, Ocke already implemented most of what's needed.
>
> Are you aware of an issue requesting this feature?
>
> ciao
> Frank
>