Problems with 6.01 and TeeChart 4 pro

rbuser

1. After installing 6.01 all forms containing a teechart is not converted .
The data is not set.
2. If i connect the Data like before, the controls only shows "0" , but in
the data-tab there are a lots of data.
3. In Teecart i could only picup the SqlAlias-Fields like sum. The naming of
that field is very unfriendly, so the old version took a beter name like
sum(var). Perhaps this is bacause no data is shown.

chris

nardmoseley

What version of Delphi are using? And what exact version of TeeChart?

rbuser

i am Using RB 6.01
Delphi 5 with SP
TeeChart 4.03

Under RB 5.6x all was ok.
The Database is an MSSQL-Databas with ADOExpress.

If you have an SQL-Server 2000 i could send you an backup of the database,
so you can try it out.
Also i could send you our application with an short description to install.

The thing is, that the data in the data-tab will be generated ok and the
datapreview shows all that data.
I think its something with calucalted Fields Sum and so.

chris

rbuser

I found some more Info.

The bug is the alis from the QueryDesigner

This is the original Statement, rendred by the QueryDesgner:
========================================
SELECT PIVOT_RechnungPos.Monat,
PIVOT_RechnungPos.Monatsname,
PIVOT_RechnungPos.MonatsnameSort,
PIVOT_RechnungPos.Jahr,
SUM(PIVOT_RechnungPos.Vk) SUM_PIVOT_RechnungPos_Vk,
SUM(PIVOT_RechnungPos.Ertrag) SUM_PIVOT_RechnungPos_Ert
FROM PIVOT_RechnungPos PIVOT_RechnungPos
WHERE ( PIVOT_RechnungPos.Jahr = 2001 )
GROUP BY PIVOT_RechnungPos.Monat,
PIVOT_RechnungPos.Monatsname,
PIVOT_RechnungPos.MonatsnameSort,
PIVOT_RechnungPos.Jahr
ORDER BY PIVOT_RechnungPos.Monat



This statement is changed by myself:
=========================
SELECT PIVOT_RechnungPos.Monat,
PIVOT_RechnungPos.Monatsname,
PIVOT_RechnungPos.MonatsnameSort,
PIVOT_RechnungPos.Jahr,
SUM(PIVOT_RechnungPos.Vk) SumVk,
SUM(PIVOT_RechnungPos.Ertrag) SumErtrag
FROM PIVOT_RechnungPos PIVOT_RechnungPos
WHERE ( PIVOT_RechnungPos.Jahr = 2001 )
GROUP BY PIVOT_RechnungPos.Monat,
PIVOT_RechnungPos.Monatsname,
PIVOT_RechnungPos.MonatsnameSort,
PIVOT_RechnungPos.Jahr
ORDER BY PIVOT_RechnungPos.Monat


The problematicle line is:
SUM(PIVOT_RechnungPos.Vk) SUM_PIVOT_RechnungPos_Vk,

if i change the Alias then the ChartControl gives me this Field in the
Combobox for Fieldnames. If i took that autogenerated name, it does not
work.
If i use that one by changed myself it works.

In older ReportBuilder it took not that fieldname it took the Alias from the
FieldEditor. like Sum(Vk), this was short and it was working.

Now on 6.01 it took the SQL Alias (which was equalk rendred in 5.56).

Hope this helps
chris