Problem with Sub Totals calculation
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
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
This discussion has been closed.
Comments
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