Calc error

rbuser

Hi all,
i have create a simple report with RB Enterprise 6.03 that sum in the footer
band some
numbers that are printed in a column in the detail band but in some pages
the total that is printed sum also the next value that is printed in the
next page.

The report is very simple:
in the dynamic detail band i print a value using a TppDbText and i have two
rows:
the first where i print the value and the second where i print a description
in some cases; the band can contain one or two rows (when the description is
visible).
In the detail band i have inserted a Tppvariable (variable1) to totalize the
value of the field where in the oncalcevent i have coded:
Value := value + dataset['FIELDNAME'];

In the footer band i have a inserted a variable where in the oncalcevent i
have inserted the code:
value:= variable1.value;

When i print the report, for some pages, the total that is printed in the
footer is wrong and sum also the value that is printed in the next page.

Thanks in advance for alla the answer.

Massimo

nicocizik

Hi Max,

This is a limitation of ReportBuilder that existed in versions before RB 9.
It involved calculating a value in the page footer with a dynamic height
detail band. This limitation was removed for RB 9.x or later.

One option is to use a static height detail band. Another is to consider
upgrading your version of ReportBuilder to the latest version (RB 10.04).

--
Regards,

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

rbuser

Thanks Nico for the answer,
i will upgrade to the new version as soon as possible but
my application is written with delphi 5
and i can't install the last version of RB with this version
of Delphi.

There isn't another solution to solve this problem
(may be writing a function in rap mode or other) ?

Thanks.

Massimo

nicocizik

Hi Massimo,

Unfortunately the only robust workaround is to use static height detail
bands. You may also try keeping the value in a group footer however this is
very difficult if you need to show the page value. The limitation was due
to the calculation time of variable or DBCalc in respect to the engine
knowing when it is out of space and needs to move to the next page. It took
some time to remove this limitation and required a re-design in how these
variables were calculated and cached.

--
Regards,

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

rbuser

Hi Nico,
do you have some examples to use a group footer to sum
at the end of a page ?

Thanks

Massimo

nicocizik

Unfortunately we do not have any examples that show this type of report. As
I mentioned before, ReportBuilder 7.x and earlier were simply not designed
to do what you need.

--
Regards,

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