Summary Grouping on TeeChart

rbuser

Howzit,
Using Delphi 5, RB 6.03, TeeChart 5.02
Looking at the TeeChart v5 demo, it is advertised under Database Charts |
Summary Grouping that one can set a "Group By" field for chart on DB
pipelines. I wan't to create a simmilar chart in RB, a point chart that
averages values grouped by another field.
So:
Bottom Axis Value = average of field X for all of field Z = "Category1"
Left Axis Value = average of field Y for all of field Z = "Category1"
I cannot find how to set this up.
Gilbert Grant
Cura Risk Management Software

digitalmetaphors

Can you create this chart with a chart component on a form outside of RB?
You may have to create a separate pipeline in order to provide the grouped
summary records. RB's wrapper for Teechart has limitations, including the
inability to support series based on other series and the inability to
traverse datasets. Most likely, to support the grouping, the chart is going
to try to traverse the dataset and this is something that our wrapper does
not support.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Yes, i can. When using a TDBChart, the first drop-down under the Series's
Datasource tab giver the options:
Manual
Random
Function
Single Record
Summary
Dataset
Text File

The TppDPTeeChartControl has:
Manual
Random
Function
Text File
Data Pipeline

The "Summary" option is the pertinent one. I presume that the inablility of
TppDPTeeChartControl to traverse data is the issue here. This is an
important piece of functionality to us, so i would like to investigate the
possibility of extending your wrapper to include this functionality. I would
also assume that the lack of this functionality in your wrapper is due to
probems encountered whilst trying to implement it. What is the possibility
of this being included?
Regards,
Gilbert

p.s.
The "Function" option for a TppDPTeeChartControl series's Datasource allows
one to base a series on a number of other series'.

nardmoseley

ReportBuilder connects the series to a DataPipeline. The DataPipeline simply
traverses the data.

Options:

1. You can link the detail data to a master pipeline and RB will only
traverse a subset of the records for each master record.

2. You can create a summary query that contains summarized results and
generate a chart off of that data.




--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

How would an end-user create a summary query? How would and end-user
generate a master-detail relationship to represent the sub-sets that are
required?

digitalmetaphors

An end user can use the Data Access Development Environemt (DADE) in order
to visually create a query that is a summary query. The summary would not be
master detail, but simply a joined dataset so that all the records can be
aggregated together for a calculation on a single dataset. Check out the end
user demos which include the Report Explorer and in those reports there are
visually created query dataviews which are located inside each report
template. See the installed Developer'sGuide PDF for more information on
using and deploying DADE for the end user.


Cheers,

Jim Bennett
Digital Metaphors