dcSum lost one record while printing in group
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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.
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
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
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