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

Page Totals

edited September 2005 in General
Hi

I'm trying to display the sum of the items displayed on each page. I
initially had a TppVariable on the detail band, which updated the value
of a TppVariable on the FooterBand. This worked, except when the
description of the item (which is a TppDBMemo) causes the detail band to
be wrapped to the next page. The amount for the item is added to the
total for the page before the one on which it appears.

I took at look at the program you posted a while back
(PageFooterSum.zip). I couldn't do the totaling in exactly the same way
as your example - the amount might be the same for two successive items;
so I changed the code to make use of the key for the row, instead. This
code still exhibited the same behaviour.

I altered the PageFooterSum example to make use of the biolife.db from
DBDEMOS. This then exhibited the same problem. In doing so, I noticed
one difference between the example and my situation - the detail band is
inside a region with KeepTogether set to true. I'm not sure how this
would affect the situation. I have sent the altered example to
support@digital-metaphors.com.

Kind regards
Gareth Marshall

Comments

  • edited September 2005
    Hi Gareth,

    Which version of ReportBuilder are you using? Providing page sums with a
    dynamic detail band was a limitation untill the release of RB 9.0. Starting
    in RB 9.0 some enhancements were made to improve upon this limitation but
    there are still some conditions that do not function correctly. My
    suggestion is to download a trial version of the latest ReportBuilder (9.02)
    and test your report with that.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2005
    Hi Nico

  • edited September 2005
    Hi Gareth,


    I apoligise, I did not receive anything. Did you email it to
    support@digital-metaphors.com? If possible, please re-send the email with
    the example report and I'll take a look at it for you.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2005
    Hi Nico


    I sent two example reports to you yesterday and again this morning. Did
    you manage to receive them?

    Kind regards
    Gareth Marshall
  • edited September 2005
    Hi Gareth,

    Yes, thank you for the example. I will take a look at it and send you a
    response today.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited October 2005
    For anyone looking for a solution to this issue, Nico has said that it
    should be fixed in release 9.03.
This discussion has been closed.