Why DBChart doesn't see calculated fields

From: "*ryspek*" <ryspek@xxxxxxxxxxxxxx>
Date: Sat, 21 Oct 2006 09:45:07 +0200

I have got source DataSet:
DataSet.SQL = SELECT Who, Data_m , COUNT(Data_m) as Number

FROM .... WHERE ... GROUP BY Who ORDER BY Who

I want to have Data_m on ax X and Number on ax Y

but unfortunately DBChart see only Data_m field

and doesn't see calculated field Number (persistent).

Why?
If is possible walk round this problem?

With best regards
ryspek

.

Prev by Date: Re: Calling dot.net code/assembly from a webpage ?
Next by Date: hi
Previous by thread: Calling dot.net code/assembly from a webpage ?
Next by thread: hi
Index(es):
- Date
- Thread

Relevant Pages

Re: Pivot calc field
... I think the problem may be that a calculated field is what is required, ... field based on the different values stored in a single column of data, ... regards.. ... steven1001's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30757 ...
(microsoft.public.excel)
Re: Problems with APPEND
... I knew it wasn't a filtered table based on the calculated field and the ... GROUP BY clause. ... Regards, ... Sietse Wijnker ...
(microsoft.public.fox.helpwanted)