Calc Field

rbuser

Hi there,

This is for RB 7.04, Delphi 5.

I have a report which in the Query designer I have created a calc field.

The sql produced in Query Designer is just

select sum(table.AMOUNT) SUM_table_AMOUNT
from table
where Field1 = 'ABC'

No matter what I try (ppDBText, OnGetText for ppLabel event) I can't
access this field to display the value.

I also have RB 9.03 Delphi 6 and it works fine. Is there a workround for
Delphi 5?

Cheers
Carl

nicocizik

Hi Carl,

This is not a known issue. In my testing with RB 7.04 and Delphi 5, I did
the following using the DBDEMOS database.

1. Opened the designer and clicked on the data tab.
2. Created a new DataView connected to the Orders table in the DBDEMOS
database.
3. Added a Calc field SUM(AmountPaid)
4. Added Search criteria WHERE OrderNo = 1221.
5. Returned to the design and used the calc field in the report.

Below was my SQL generated...

SELECT SUM(orders.AmountPaid) SUM_orders_AmountPaid
FROM "orders.db" orders
WHERE ( orders.OrderNo = 1221 )

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com