Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

TeeChart dont work with RB 6.01 and Calcfields

edited August 2001 in General
I found some more Info with the TeeChart Problem.
To Remaind: TeeChart is on CalcFields always zero. The Dataviewtab shows
Data.


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

Comments

  • edited August 2001
    i have read about some problems with _ in Alias, perhaps its the same like
    in my problem.
    The Fieldalias is generated automaticly on calcfields with _. Perhaps
    TeeChart coud not understand _.

    chris
This discussion has been closed.