Sub-Report Sum Calculation

[wizcow]

Hello

I am building a daily cash out report.

The report has a sub report that shows all of the days Invoices.

What I'm trying to do is to Total all of the Invoice Totals.

On the subReport I have a text box named [LineItemTotal] that Totals the items;
=Sum([LineItem])
This give me a Total for that Invoice

Now, on the Main Report, I have added a text box and want to Total all the Invoices.

I have tried
=Sum(Report![SubReport]![LineItemTotal])
But the text box is always empty.

What am I doing wrong?

Tom

 

[doss]

Try

=Sum([Reports]![MainReport]![SubReport]![LineItemTotal])


The computer may be confused about which report you are talking about........this way it will know exactly.