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

ppVariable problem

edited April 2005 in General
RB 9.02 Ent
D7 Ent

I have 4 variables:
one on the detail band - CalcType=veTraversal, ResetType=veTaversal
one on 2 different group bands - CalcType=veTraversal,
ResetType=veGroupEnd
One on the summary - CalcType=veTraversal, ResetType=veReportEnd

In the OnCalc Event I do my calculations and add the results together.
I use the same OnCalc Routine for all variables since they all do the
same thing.

I also have an OnFormat Event that is connected to all 4 variables that
will format the text based on the Value passed in.

The 2 variables on the groups and the one on the summary work perfectly.
The problem is with the one on the detail band. It seems to reset
itself before it reaches the OnFormat event because the value passed in
is 0.

I'm pretty sure I'm just missing something but I can't seem to find
what it is.

--
Rick Dement
Ideal Software Systems, Inc.

Comments

  • edited April 2005
    Hi Rick,

    Using a Calc on Traversal and Reset on Traversal combo with a Variable
    inside the detail band will probably not give you the effect you are after.
    This combination should only give you 0's or blank text. For a Variable
    inside the detail band, I would suggest leaving the Reset option to
    ReportEnd and handling all updates of the Value property to the event code
    inside the OnCalc event. Since this code will be firing every traversal
    anyway, there is no need to reset the variable as well.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2005
    Be careful of using TppVariable Oncalc event because it seems it has some
    bug which fires more than once per record transversal

  • edited April 2005
    Hi Peter,

    This is not a known bug in ReportBuilder. Are you able to recreate this
    issue with a simple example? If so, please send it in .zip format to
    support@digital-metaphors.com and I'll take a look at it.

    --
    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.