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

Variable

edited May 2002 in General
I have a variable I created in a summary band and has OnCalc of:

value := frmreports.ppDBCalc7.Value + frmreports.ppDBCalc8.Value +
frmreports.ppDBCalc9.Value +
frmreports.ppDBCalc10.Value + frmreports.ppDBCalc11.Value +
frmreports.ppDBCalc12.Value +
frmreports.ppDBCalc13.Value;

where the dbCalc's are all sum values also in the summary band. If I trace
through the code, the value is calculated correctly in the OnCalc code. When
the report generates, my value is 0 though. Any clue? (Reset does not fire
after value is assigned).

--
Chris Yoder
Programmer
Stven J. Baum, P.C.

Comments

  • edited May 2002
    The problem most likely is that the variable's datatype is set to string
    (default). You'll need to set it to double or integer for your numeric
    calculations.

    You could also use a variable component for each of the other calcuations
    instead of a DBCalc. Their is a CalcOrder property which applies to the
    order in which the OnCalc event is fired when a calculation in a variable is
    relying on the value in another variable in the band when the variable's
    value needs to fire in order. His property only applies to components in a
    single band, it does not work across multiple bands.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.