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

ppVariable value changes on a new page

edited March 2006 in General
Hi,

I have a running total variable which calculates fine till the end of page
but on the next page it starts with an incorrect value and carries on fine
till the end of page then again it starts with an incorrect value on the
next page.
What am i doing wrong.
I have Delphi 7 and Report Builder 9

Thanks

Mansoor

p.s. there used to be a "calculation" item whenever you right clicked on a
numeric variable in version 7 but i can't find it in version 9. Where is it
?

Comments

  • edited March 2006
    Hi Mansoor,

    Which version of RB are you using? (9.0, 9.01, etc.). We made some changes
    to the way calculations are made and stored across pages for RB 9. Where
    are you calculating these sums? Are any variables inside the page footer
    band? What is the layout of your report and how are the variables/DBCalcs
    setup?

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2006
    Hi,

    I am using version 9.01. The calculation is in the Group Footer Band
    Following is the report structure
    -----------------------------------------------------
    Heading
    ^Header
    ^Group Header[0]: Branch
    ^Group Header[1]: Leadtime
    ^Detail
    BranchName Leadtime ppDBText1 ppVariable1
    ppVariable2
    ^Group Footer[1]: Leadtime
    totals for Branch
    ^Group Footer[0]: Branch
    ^Footer
    ^Summary
    ------------------------------------------------------
    Following is the output
    ------------------------------------------------------
    Page Headings
    Column Headings

    Branch1 0 35
    10.00% 10.00%
    Branch1 1 20
    7.50% 17.50%
    Branch1 2 10
    2.75% 20.25%
    and so on until Branch1 ends and the totals for the Branch1 is printed
    then the next Branch data is printed and so on
    The last column is the running total which is creating a problem
    I tried putting the formula for ppVariable2 (running total) in the "OnCalc",
    "GroupFooterBandBeforePrint" in the "OnCalc" of ppVariable1
    ppVariable2.Value := ppVariable2.Value + ppVariable1.Value;
    but all of them give the same result i.e. on the first page it is fine but
    if the Group goes onto the next page the the ppVariable2 changes to a
    different value
    which gives wrong result

    There are other reports also which were built in version 7 and now behaving
    abnormally in the version 9.01. I am confused as to what i should do now.
    Do you have any manual which describes how the calculations are done in
    version 9.01 or any demos

    Thanks

    Mansoor


  • edited March 2006
    Hi Mansoor,

    Upgrading to RB 9.03 should solve this issue. Please send an email to
    info@digital-metaphors.com for upgrade information.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2006
    Hi Nico,

    Thanks for the quick reply.

    Mansoor


This discussion has been closed.