Sum Subreport totals

[hughess7]

Hi all

I have a report which has several group headings, the first one being Level
(0-5), 5 appearing at the top of the report. The 2nd level is ClaimNo, each
claim appears only once on the report. Underneath each claim header is a sub
report listing all the Issues found with the claim and another subreport
listing financials. The financials are one or two levels max, shown in desc
order. Each level has some claim values against them

eg

ClaimNo 123456
Levels 5 Labour, Parts, Sublet
Levels 4 Labour, parts, sublet

Claim No 234567
Levels 4 Labour, parts, sublet

Claim No 345678
Levels 4 Labour, parts, sublet
Levels 0 Labour, parts, sublet

I need all the levels to be summarised with totals at the end of the report.
I achieved this via another sub report just for the summary but when printing
(preview looks ok) I am getting an error 'cannot open any more databases' and
the summary is not printed. I'm struggling with trying to get the summary
from the report without adding another subreport - is this poss?

Thanks for any help...