[Openroad-users] Clickpoint problems with SegmentShape

[Chris Wallace]

Jim,

While you provided information on what your issue is with using
Clickpoints, which probably rules out their use, you haven't explained
the type of interaction you're trying to achieve.

We have and OpenROAD-based ad-hoc query tool that integrates with
Microsoft Excel for producing Pie and Bar charts (plus a number of other
facilities).

We also have a facility for producing a dashboard of user-definable set
KPI gauges (half pies with coloured segments). 

The KPI gauges are drawn in OpenROAD code, where-as the Excel Pie charts
are created by a macro that takes the raw data, converts it to a pivot
table and then charts it.  The Pie and Bar Chart macros provide a first
cut chart that users can then manipulate further, if they wish.  We are
currently looking at converting the Excel charting facility to use Open
Office, thus eliminating any licensing issues for clients.

There are overviews of these facilities at:

http://www.miswa.com.au/pdfs/Query%20Manager.pdf 
(Excel output examples on pages 36-38)

http://www.miswa.com.au/pdfs/KPI%20Mentor.pdf 

The overviews of these facilities are shown in the context of our
HR/Payroll application, but they can operate independently.  Note: the
Query Manager does require a meta-data definition to operate against
foreign data sources.

Regards
Chris Wallace
Management Information Systems (WA) Pty Ltd
Level 9, Ingres House
Adelaide Terrace, PERTH  WA  6000
Ph: (08) 9221-9221  Fax: (08) 9221-9224
Email: chrisw at miswa.com.au
Web: http://www.miswa.com.au

Disclaimer:  Management Information Systems (MIS) is a wholly-owned
subsidiary of Ingres Australia P/L
This e-mail is private and confidential. If you are not the intended
recipient, please advise us by return e-mail immediately, and delete the
e-mail and any attachments without using or disclosing the contents in
any way. The views expressed in this e-mail are those of the author, and
do not represent those of MIS unless this is clearly indicated.  You
should scan this e-mail and any attachments for viruses.  MIS accepts no
liability for any direct or indirect damage or loss resulting from the
use of any attachments to this e-mail.

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Antill, Jim
Sent: Tuesday, 16 October 2007 18:17
To: openroad-users at peerlessit.com
Subject: [Openroad-users] Clickpoint problems with SegmentShape


Hi,

I'm having quite a bit of difficulty accurately detecting a
childclickpoint
event on a segment shape within a composite and was wondering if anyone
else
had found a solution to similar problems. I'm using OR4.0 .

The problem seems to be that when a childclickpoint event is detected
the
formfield itself doesn't pick the event up. Rather the coordinates of
the
clickpoint are taken and the array of fields within the composite gone
through to find the first field that contains the clicked on position.
That
works pretty well for rectangular shapes (as most OpenROAD fields are).
However, in the case of segment shapes it seems that a box is formed
from the
start and end points and points within this are checked rather than
points
that fall on the line itself. So if you have segments that are close to
each
other, but not overlapping, the wrong segment is invariably picked up. I
have
some example code here that demonstrates the problem. If anyone is
interested
I'll post it up.

More worryingly this can result in code being fired in error as any
clickpoint code behind the segmentshape that OpenROAD mistakenly thinks
was
clicked is then executed.

As you can imagine this leads to severe problems when doing things such
as
Pie Charts which isn't an unusual requirement. I have tried to use
MSGraph in
the past but had a number of issues with it's behaviour with OpenROAD
(mainly
due to sizing). This might be improved with OR2006 I guess.

So, my questions are: Does anyone know whether this behaviour will be
changed
in OR2006, will we be given better drawing tools in the near future e.g
draw
a filled arc in a circle etc. and has anyone a favourite alternative to
graphing that allows interaction between the graph and OpenROAD?

Thanks for any advice.

Regards,
Jim

************************

This message has been delivered to the Internet by the Revenue Internet
e-mail service (OP)

*************************

________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

To unsubscribe click on this link
mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe

To subscribe click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe