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

dcSum lost one record while printing in group

edited September 2008 in General
Hello,

When printing an invoice I identified a strange problem. First i show you a
sample of the structure of my report.

Pageheader:
General information (customer, date, invoice nr)

Group (Invoice ID)
Header titles
Label amount (sum group of previous page only visible when invoice has
more than one page)

Group Detail
Invoice lines (amount)

Group footer
Total amount Group (ppdbcalc dcSum).

Summary

total amount invoice.


Page footer
(empty).

Page 1 is correct,
Page 2 of the invoice, amount of page 1 is correct but amount of group isn't
correct, the group lost one of the records from my dataset
Page 3 last seems to be correct.

I've created an demo-application which reproduces my problem.

I hope that someone can help me with this problem

Kind Regards,
Dees

Comments

  • edited September 2008
    Hi Dees,

    For future reference, please do not post attachments to these newsgroups.
    Send them to support@digital-metaphors.com.

    Which version of ReportBuilder and Delphi are you using? Have you tried
    calculating the sum using a TppVariable component rather than a DBCalc?

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2008
    Hello Nico,

    i'm using Delphi 2006, Report builder 10.06 and trial 10.09 (doesn't solve
    the problem).

    i'm not familiar working with tppVariable. evertyhing i try gives me result
    0. I need to see the group-total.

    thx in advance.


  • edited September 2008

    Try unzipping your demo and running it on your machine. It does not
    compile - has a reference to a unit that must have renamed. So fix that.
    Then run again. Note that the dbCalc is not in the subreport group footer,
    it is in subreport footer. It does not show up in preview because pbChild
    subreports do not have page footer. Perhaps you meant to place that in the
    group footer? I also notice that you have about 400 lines of event-handler
    code in the report.

    Can you make a new demo. Fix the errors and remove all the event-handler
    code. Perhaps create a new demo from scratch might help. Also include
    information about what is wrong - what is the result that you expect to see.
    Send to support@digital-metaphors.com and we can check it out.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited September 2008
    Hello,

    i'm trying to create a new demo application.

    Reason why the 'group' summary in the subreport footer is placed, is because
    it have to be printed on every subreport-page-footer (except the last page).
    this invoice has four implementations with different a body.

    Demo application works fine here, which unit must be renamed?

    Is it possible to print the group footer every page even if the group isn't
    ended yet?

    greats,dees

  • edited September 2008


    Here is an example that simulates a group footer on each page.

    www.digital-metaphors.com/tips/GroupFooterOnEveryPage.zip


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.