DBCalc on Main report to show totals from Sub report

rbuser

Delphi 5 Pro
RB 7

I have a master/detail relationship with Group Breaks in both the Main
report and the Sub report. I'd like to show a sub-total in the Main report
in the GroupFooter as well as the Report Summary sections. These sub-totals
will be from the amounts displayed in the Sub report.

I added a DBCalc to the GroupFooter and ReportSummary sections on the Main
report and set the Pipeline and DataField to the appropriate values from the
Sub report. Only, the DBCalc values always show as 0 (zero). Is this not the
correct way to handle this? Can someone explain how I might accomplish my
goal?

Thanks,
Michael

nicocizik

Hi Michael,

Take a look at the following article and example.

http://www.digital-metaphors.com/rbWiki/Delphi_Code/Calculations/How_To...Display_Subreport_Totals_in_the_Main_Report


Going forward hope you will be upgrading to RB 12, which includes many
powerful new features.

Here is a link to What's New for RB 12. (Use the side menu to navigate to
more detail).

http://www.digital-metaphors.com/rbWiki/General/What's_New/RB_12

Also note that we have launched rbWiki, a great RB 'How To' resource that
contains hundreds of tech tips and downloadable code examples.

http://www.digital-metaphors.com/rbWiki

--
Regards,

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

rbuser

Many thanks for the quick reply. I appreciate the link to the RBWiki page.
That should be some great help moving forward.

Btw, I have already upgraded to RB12 but unfortunately, RB12 is not
supported in Delphi 5. I still have supported projects in Delphi 5 so I'm
restricted to using RB7 for that version of Delphi.

Thanks again,
Michael