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

Calculated fields ....

edited October 2003 in General
Hello,

I need to design a report with the following considerations: First I
have a group in the report. Because of the data, I need to show info in
the header of the group and on detail band. So far so good. Now, I need
to put some results in the footer of the group. My problem is that
these results are calculated using some data from the header, and some
data from the detail part.

GROUP HEADER
FIELD 1
FIELD 2

DETAIL
FIELD 3

GROUP FOOTER
FIELD 1 + FIELD 2 + SUM(FIELD 3)

What are the correct events that I need to use in order to calculate
group's footer results?

Thanks in advance
Luis Ximenez

Comments

  • edited October 2003
    Hi Luis,

    Your best approach would be to use TppVariables to make all your
    calculations. Place variables in your header and detail bands and in the
    TppVariable.OnCalc event, pull the data directly out of the pipeline to be
    displayed and make the necessary calculations to update a third set of
    variables in the footer.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.