ppVariable value changes on a new page
Hi,
I have a running total variable which calculates fine till the end of page
but on the next page it starts with an incorrect value and carries on fine
till the end of page then again it starts with an incorrect value on the
next page.
What am i doing wrong.
I have Delphi 7 and Report Builder 9
Thanks
Mansoor
p.s. there used to be a "calculation" item whenever you right clicked on a
numeric variable in version 7 but i can't find it in version 9. Where is it
?
I have a running total variable which calculates fine till the end of page
but on the next page it starts with an incorrect value and carries on fine
till the end of page then again it starts with an incorrect value on the
next page.
What am i doing wrong.
I have Delphi 7 and Report Builder 9
Thanks
Mansoor
p.s. there used to be a "calculation" item whenever you right clicked on a
numeric variable in version 7 but i can't find it in version 9. Where is it
?
This discussion has been closed.
Comments
Which version of RB are you using? (9.0, 9.01, etc.). We made some changes
to the way calculations are made and stored across pages for RB 9. Where
are you calculating these sums? Are any variables inside the page footer
band? What is the layout of your report and how are the variables/DBCalcs
setup?
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I am using version 9.01. The calculation is in the Group Footer Band
Following is the report structure
-----------------------------------------------------
Heading
^Header
^Group Header[0]: Branch
^Group Header[1]: Leadtime
^Detail
BranchName Leadtime ppDBText1 ppVariable1
ppVariable2
^Group Footer[1]: Leadtime
totals for Branch
^Group Footer[0]: Branch
^Footer
^Summary
------------------------------------------------------
Following is the output
------------------------------------------------------
Page Headings
Column Headings
Branch1 0 35
10.00% 10.00%
Branch1 1 20
7.50% 17.50%
Branch1 2 10
2.75% 20.25%
and so on until Branch1 ends and the totals for the Branch1 is printed
then the next Branch data is printed and so on
The last column is the running total which is creating a problem
I tried putting the formula for ppVariable2 (running total) in the "OnCalc",
"GroupFooterBandBeforePrint" in the "OnCalc" of ppVariable1
ppVariable2.Value := ppVariable2.Value + ppVariable1.Value;
but all of them give the same result i.e. on the first page it is fine but
if the Group goes onto the next page the the ppVariable2 changes to a
different value
which gives wrong result
There are other reports also which were built in version 7 and now behaving
abnormally in the version 9.01. I am confused as to what i should do now.
Do you have any manual which describes how the calculations are done in
version 9.01 or any demos
Thanks
Mansoor
Upgrading to RB 9.03 should solve this issue. Please send an email to
info@digital-metaphors.com for upgrade information.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Thanks for the quick reply.
Mansoor