Calculated Fields

rbuser

Hi,
RB V7.3 and Delphi 6.
We have been using RB for a while now and we found it absolutely brilliant.

I came a cross a request from one of our users in which they want to achieve
the following task.

They have a quantity column and a cubic volume column, and they want to be
able to sum up the cubic volume column, but needs to take into account the
quantity (i.e. quantity * cubic volume). To achieve this in Delphi we would
have to have a calculated field which then can be exposed to the report, but
the problem is that this cubic volume field is a custom field, which the
user added to the database, so we have no knowledge of it.

I am just wondering if there is a way around it or may be the version of RB
caters for calculated fields.



Regards

Nas

Adaptev Ltd

www.adaptev.com

nardmoseley

RB Enterprise includes a Calc workspace that provides a run-time Pascal
environment for coding calculations and event-handlers. This enables the
code to be saved as part of the report definition - outside of the
executable. You can create a TppVariable and then use the OnCalc event to
perform the calculation.



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com

rbuser

Hi Nard,



I am afraid we only use the professional version, so I take it that there is
no way around it using the PRO version?



Nas

nardmoseley

I recommend upgrading to RB Enterprise. The requirement you describe is
exactly what RB Enterprise provides an powerful, elegant solution for.

With RB Professional the end-user reports are more limited. Any code that
you write has to be Delphi code - compiled into the .exe. The other
alternative is to perform the calculation using SQL.


--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com