I have a report where I need to Muliple to dbtext components on a report. I've looked but can't find any components when I can do the calculation. I've looked at DBCalc but its DBCalcType says nothing about this.
There are two options for performing any type of a calculation on a DBCalc. You can perform the calculation in the Query. That means either calculating a new field either in the actual SQL statement or in the Calcs tab of the query designer by selecting expression for the Function type. The newly calculated field will then be available on the data pipeline. The other option is using a variable component instead of a DBText or DBCalc. With a variable you can then either perform needed calculations in Delphi or RAP by using the variable's OnCalc event.
Comments
You can perform the calculation in the Query. That means either calculating
a new field either in the actual SQL statement or in the Calcs tab of the
query designer by selecting expression for the Function type. The newly
calculated field will then be available on the data pipeline. The other
option is using a variable component instead of a DBText or DBCalc. With a
variable you can then either perform needed calculations in Delphi or RAP by
using the variable's OnCalc event.
--
Cheers,
Alexander Kramnik
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com