By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,461 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,461 IT Pros & Developers. It's quick & easy.

several questions regarding graphs

P: n/a

I use MS Graphs nested in reports, extensively. They show subset of report's
recordset by linking master/child fields. While reports are based on
pass-through queries (PostgreSQL), my graphs are based on local tables which
content is refreshed from pass-through queries. The reason for that is
because I determined that it is 20 times faster than to base graphs directly
on pass-through queries.
In order to avoid known problem with synchronizing graph with report, when
graph doesn't represent values correctly, I have OnFormat event of a section
with nested graph, that requeries the graph.
My questions are following:

1. There are 5 master/child fields that are used to synchronize content of
graph to corresponding records in report: "department", "plant",
"sampling_type", "area" and "sample". They are normally not visible in
graph, because it's values are textual (both on server and in local tables
these fields are text/varchar type). Everything works OK as long as all
entered values in these fields are recognized as text. But, if a user enters
some number-like value for some of these textual fields (for example "12"
for "area"), MS Graph seems to recognize it as a number data type instead
of text data type, so it is shown in graph as a number, which is not OK,
because the actual value is a text and should not be represented in graph as
a number.
So, I was looking in MS Graph datasheet and there is an option for formating
field data type. I choosed "text" in all fields, but it didn't help, MS
Graph still shows all textual number-like values as numbers, although fields
in tables and in graph datasheet are declared to be text...How to solve it ?

2. How to force MSGraph to select subset from report's recordset, instead of
independent query for graph?

3. There are many reasons why I don't like MS graph control, so I'm
wondering is there any freeware or commercial alternative to MS Graph, that
could be nested in reports?


Dec 16 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.