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

Conditional summing

edited July 2005 in RAP
Hi!
I have a question about conditional summing on a subreport. The pipeline has
a field (named type), which can have 2 different values. I calculate the
group using ordinary DBCalc component but I was wondering if there is a way
of having two DBCalc components, of which oe would sum the field Value only
when the the value in field Type would have value L, while the other would
sum the same but only when the field Type doesn't have the value L. Any
ideas?

Best regards,
Goran

Comments

  • edited July 2005

    You need to use TppVariable components and the TppVariable.OnCalc event.

    See the Calculations thread of the Tech Tips newsgroup for an overview of
    how to perform calculations. Also see the Developers Guide and Learning RAp
    end-user guid for tutorials on performing calculations.

    DBCalc is limited to performing very simple calculations.



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


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited July 2005
    Many thanks, it works nice :)

    Regards,
    Goran

This discussion has been closed.