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

Disappearing values

edited June 2008 in General
Hello,

In my report I have two columns: a category name, and a count of how many
records match that particular category name. So for example I have:

sales department 86
billing dept 15
IT 24

The report display the information fine, however once a user advances one
page, then comes back to the first page, some of that information is missing
or incorrect. An example of the output on the screen would be:

sales department
billing dept
IT 1



I don't think it a programming error because it displays it correctly the
first time that page is loaded. Any suggestions?

Thank you,
Ray

Comments

  • edited June 2008
    Hi Ray,

    Try setting the Report.CachePages property to True and see if that solves
    the problem.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited June 2008
    Unfortunately, that did not fix the problem. I should add that I am using
    Delphi 5 with ReportBuilder version 7. Should I try anything else ?


  • edited June 2008

    Make you are using the TppVariable and it's OnCalc event to perform
    calculations, this is convered in the Developers Guide. Using external
    variables to try to calcs will produce exactly the incorrect result you are
    describing.

    Here is a tech tip...


    Calculations in ReportBuilder are performed primarily using
    the TppVariable component.

    a. Set the Variable.DataType

    b. Code the calculations using the Variable.OnCalc event.

    c. Use the Timing dialog to control the timing of the OnCalc event.
    To access the Timing dialog, right click over the Variable
    component and select the Timing... option from the speed menu.

    d. Set the LookAhead property to True, when you need to display
    summary calculations in the title, header, group header, etc.

    e. To perform calculations based on the results of other
    calculations use the Calc Order dialog of the band. To access
    the Calc Order dialog, right click over the Band component
    and select the Calc Order... option from the speed menu.


    By using TppVariable components ReportBuilder will take care of caching
    intermediate results of accumlated calcs that cross pages.

    There are a number of calculation examples in the main demos.dpr
    project.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.