Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

First row summing twice

edited November 2011 in General
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

Comments

  • edited November 2011
    Hi Ricardo,

    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.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2011
    Upgraded to 10.09 and the issue remains.

    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

  • edited November 2011
    Send the example to support@digital-metaphors.com in .zip format.


    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2011
    Just sent the e-mail with subject "Problem With Vars"

    Thanks.

This discussion has been closed.