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

Grand totals miscalculated when report exceeds more than one page

edited September 2003 in Subreports
Hi.

I'm using Delphi 7 Pro with RB std. 7.03.

My report is designed as follows:

Mainreport (Dagsregnskab)
Subreport1 (Pr. date)
Subreport2 (Fordelt pr. betalingsform)
Subreport3 (Fordelt pr. produkt)

The Mainreport has a summaryband, where I accumulate totals from Subreport1.
TppVariables are used for this purpose. The totals in Subreport1 are also
calculated using TppVariables. They total values from Subreport3 only, which
are mainly TppDBCalc using the Count or Sum function.

The totals in Subreport1 are correct, but in the summaryband of Mainreport
the totals are only correct when the report is on 1 page. If the report
exceeds more than one page, the totals are wrong (se example in attached
.pdf-file).

The Subreport1 has a group and the totals in the groupfooter are reset on
GroupEnd, are of CalcType veDataPipelineTraversal, and works just fine.
The totals in the Mainreport are reset on ReportEnd and are of CalcType
veGroupBeforeFooter. I have read in earlier posts that this is recommended
for calculating totals in the mainreport.

What should I do to solve this problem?

Regards,

Mikkel Andersen
mia@hc-venslev.dk

The totals are marked with yellow in the.pdf-file.

Comments

  • edited October 2003
    Hi Mikkel,

    For future reference, we ask that you do not post attachments to the
    newsgroups. If you need to send an attachment, please e-mail your quesiton
    to support@digital-metaphors.com.

    If possible, please send an example of your report to us and I'll have a
    look at what's going on with the calculation of the grand totals.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.