Page Totals
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I sent two example reports to you yesterday and again this morning. Did
you manage to receive them?
Kind regards
Gareth Marshall
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
should be fixed in release 9.03.