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

ppVariable and timing

edited April 2005 in General
Hi,

I have 2 Variables in a 'section' style subreport which has a detailband and
is grouped on a datafield x where i want totals for. I have 1. Variable 1 is
placed on detailband to get a running total from all records traversed.
Variable 2 is placed on the groupfooterband of the grouped datafield. In the
OnCalc event of Variable 1 I do the calculations of both Variable 1 and 2.
Why there because i want all my calculations centralised. Is this Ok? If so
with timing settings for both variables below i always get wrong values for
Variable 2 which is the total value grouped by datafield x. Which are the
correct timing settings (CalculateOn/ResetOn) when using variables for a
total/(sub)report and total/group.

Timing Variable 1
CalculateOn: Traversal DataPipeline: nil
ResetOn: ReportStart DataPipeline: nil

Timing Variable 2
CalculateOn: Traversal DataPipeline: nil
ResetOn: GroupStart DataPipeline: MyGroupedDataField

Greetings,
Filip Moons

Comments

  • edited April 2005
    Hi Filip,

    The Timing settings for Variable 1 look fine (I would use Reset On:
    ReportEnd but no matter).

    You might want to play around with the Reset time of Variable (the
    CalculateOn is unimportant because the calculations are done in the OnCalc
    of the other Variable). I would suggest trying the OnGroupEnd.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

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