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

Problem with Sub Totals calculation

edited November 2003 in End User
I have a report where I have created a group on the ID field of
my table. I want to have a Sub-Total of each group so i placed a DBCalc Item
on the group footer band and set the calculation to SUM and the Reset Group
to "ID"

When I run the report in the EndUser Reporting tool (Preview) it works fine,
but if i export the Report to File and load it dynamically in my program the
subtotals where calculated as shown:

ID Cost
----------------------------------
ABC EUR 15.00
ABC EUR 15.00
ABC EUR 15.00

Sub Total EUR 45.00

XYZ EUR 10.00
XYZ EUR 10.00
XYZ EUR 10.00

Sub Total EUR 75.00

JKL EUR 5.00
JKL EUR 5.00
JKL EUR 5.00

Sub Total EUR 90.00

Orerall Total EUR 90.00

How can I fix this?
I'm using RB 6.03 Enterprise
Delphi 5 Professional

Comments

  • edited November 2003

    When you load the report from file, I think it is encountering a naming
    conflict with some existing reports. The ResetGroup is not getting
    re-assigned.

    I think RB 7 contains a fix to this error related - you can download a trial
    version for D5 and test it. (Backup your installation and any existing
    reports).

    Otherwise you can write some code to re-assign the DBCalc's resetgroup

    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

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