Totals on a Report

[GERS]

I am trying to print totals on a report which contains a sub-report. I want
to print one line of totals in the report footer which shows totals from
columns in both the main report and also from the sub-report.

Showing the totals from the main report is fine but I cannot get the totals
from the sub-report. Any suggestions?

PS: report layout is as follows:

On Main Report On Subreport
Column 1 Column 2 Column 3 Column 4 Column 5
date Details nnnn.nn nnn.nn nnn.nn
date 1 Desc1 nnnn.nn nnn.nn nnn.nn
date 2 Desc2 nnnn.nn nnn.nn nnn.nn
date 3 Desc3 nnnn.nn nnn.nn nnn.nn
date 4 Desc4 nnnn.nn nnn.nn nnn.nn

Main Report Footer
TOTALS nnnn.nn nnn.nn nnn.nn

 

[GERS]

I should have mentioned that there may be a different number of lines on the
subreport for each line on the main report. The records are grouped on a
reference number common to both reports.