Displaying summary query in a TeeChart

rbuser

I am unable to display the fields from a summary query in a TeeChart.

Versions:
Report builder enterprise 7.02
TeeChart Pro v5.03
Delphi 7.0
Windows 2000 sp4
SQL Server 2000

I've set up a report as follows:

Added a dbchart to the report.


Added three queries to the report:

A two field summary query:
SELECT CIM_TRANSACTION.ASSEMBLY_PK,
sum( CIM_TRANSACTION.ASSEMBLY_QTY ) as quantity
FROM CIM_TRANSACTION CIM_TRANSACTION
group by cim_transaction.assembly_pk

A count query:
SELECT CIM_ORDER.DUE_DATE, COUNT(*) COUNT_2
FROM CIM_ORDER CIM_ORDER
GROUP BY CIM_ORDER.DUE_DATE

A basic three field select:
SELECT CIM_TRANSACTION.ASSEMBLY_PK,
CIM_TRANSACTION.ASSEMBLY_QTY,
CIM_TRANSACTION.ASSEMBLY_DESCRIPTION
FROM CIM_TRANSACTION CIM_TRANSACTION


I've added a bar chart to the chart from the gallery.


When I select the data pipeline for the bar chart I get the following
results:

For the two field summary query:
Labels combo box: allows me to select both fields
X and Bar combo boxes: the drop down contains no fields

The count query:
Labels, X and Bar combo boxes: contain both fields

The basic three field select:
Labels combo box: Contains all three fields
X and Bar combo boxes: Contains only the assembly_qty field.

My support engineer needs to make a summary query and I need to know why she
can't select any fields for the X and Bar properties of the chart.


Regards,

Giles.

digitalmetaphors

Hi Giles,

Can you send us an example that shows the problem to
support@digital-metaphors.com

I tried to recreate the problem using a summary query.
Win 2K
D7
RB 7.03
Teechart 5.03
DBDemos data

Here is the DBDemos SQL

SELECT orders.CustNo, SUM(orders.AmountPaid) SUM_orders_AmountPaid
FROM "orders.db" orders
GROUP BY orders.CustNo

Using a DBChart in RB, I was able to define the Bar series datasource as
such

Labels: CustNo
X: CustNo
Bar: AmountPaid

Do you have any function series defined in the chart? RB's TeeChart wrapper
does not support functions so if you have them that may be causing the
problem. Try taking the function series out of the chart and try it again.

Cheers,

Jim Bennett
Digital Metaphors