First row summing twice
Hi,
RB 10.7, Delphi 7.
I have a report with a sub-report (sub1) and I need to sum a field of this
subreport. I am using a variable to do so. My variable is configured like
this:
- formula: Value := value + ItemVenda['Total'];
- CalcType: veDataPipelineTraversal
- CalcComponent: ppItemVenda (the datapipeline in wich sub1 is connected)
- ResetType: veTraversal
When I have little data the sum is perfect. When I have many data that
causes the sub1 to break to a new page the sum is incorrect. Looking further
I can see that it sums the first element that is printed in the new page
twice. So if the first element hast 'Total' of 10 for instance, my whole sum
is incorrect by 10.
I don´t know how to avoid this first element to be summed twice.
Thanks
RB 10.7, Delphi 7.
I have a report with a sub-report (sub1) and I need to sum a field of this
subreport. I am using a variable to do so. My variable is configured like
this:
- formula: Value := value + ItemVenda['Total'];
- CalcType: veDataPipelineTraversal
- CalcComponent: ppItemVenda (the datapipeline in wich sub1 is connected)
- ResetType: veTraversal
When I have little data the sum is perfect. When I have many data that
causes the sub1 to break to a new page the sum is incorrect. Looking further
I can see that it sums the first element that is printed in the new page
twice. So if the first element hast 'Total' of 10 for instance, my whole sum
is incorrect by 10.
I don´t know how to avoid this first element to be summed twice.
Thanks
This discussion has been closed.
Comments
Which band is the variable located? Is the detail band dynamic?
My first suggestion would be to upgrade to RB 10.09 and see if that
helps. If not, please send a simple example I can run on my machine
that demonstrates the issue and I'll try to recreate it here with the
latest version of ReportBuilder.
For upgrade instructions contact info@digital-metaphors.com with your
serial number and purchasing email address.
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
The variable is located in the detail band, the same that has the subreport.
I´ll try to reproduce it in a small project and then I should send it here
or do you have any attachment politics different than that?
Thanks
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Thanks.