Error in RB 9 when using OnCaluclate and adding to a variable in a main report
Hi,
We have a report where we have 3 subreports. Each subreport shows
detail information. Each detail line in this subreport contains a
variable. In the OnCalculate of each of these variables we do
somehting like
Value := pipeline['Fieldname']
RefMainTotal.Value := RefMainTotal.Value + Value;
where RefMainTotal is a TppVariable that has been declared in the main
tab and in the main OnCreate event we have assigned it to a variable
like this
RefMainTotal := VarMainTotal
The VarMainTotal is placed in a group footer on the main report.
The timing of this variable is correct (reset on GroupEnd)
When we run the report the endresult that is shown in the VarMainTotal
is way off in the case the report contains multiple pages. When the
report contains only a single page the result is correct.
I have also checked this report against our current development
environment where we use RB 10. Here the correct information is shown.
I guess the error is in RB.
Is this a known problem and is there a solution or workaround. We
can't upgrade this client for a couple of months at least.
Also all our report are end-user reports.
regards
Paul
We have a report where we have 3 subreports. Each subreport shows
detail information. Each detail line in this subreport contains a
variable. In the OnCalculate of each of these variables we do
somehting like
Value := pipeline['Fieldname']
RefMainTotal.Value := RefMainTotal.Value + Value;
where RefMainTotal is a TppVariable that has been declared in the main
tab and in the main OnCreate event we have assigned it to a variable
like this
RefMainTotal := VarMainTotal
The VarMainTotal is placed in a group footer on the main report.
The timing of this variable is correct (reset on GroupEnd)
When we run the report the endresult that is shown in the VarMainTotal
is way off in the case the report contains multiple pages. When the
report contains only a single page the result is correct.
I have also checked this report against our current development
environment where we use RB 10. Here the correct information is shown.
I guess the error is in RB.
Is this a known problem and is there a solution or workaround. We
can't upgrade this client for a couple of months at least.
Also all our report are end-user reports.
regards
Paul
This discussion has been closed.
Comments
Which version of RB 9 are you currently using? (i.e. 9.01, 9.02). I
believe there were some fixes made for RB 9.03. Please contact
info@digital-metaphors.com with your serial number and purchasing email
address for information on how to update to RB 9.03.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Hi Nico,
We used version 9.01. I know we can upgrade to 9.03, but at the moment
that is not really an option unless it is the last solution.
A workaround of any kind would have my preference.
regards
Paul
On Wed, 29 Mar 2006 11:16:00 -0700, "Nico Cizik \(Digital Metaphors\)"
I believe this error is primarily caused by making calculations inside a
dynamic height detail band in a multiple page report. Is there any chance
you can use a static height detail band?
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com