Reporting subreport total on main report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BobV - 25 Oct 2005 23:47 GMT

I am trying to create a financial report that compares planned spending
against actual spending. Actually, I have the report basically done--using
the main report as the planned and the subreport as the actual. The planned
budget item appears first, followed by a transaction report showing spending
against that particular planned line item, which I have totalling after
each. Now, I just want to show a total at the end of the report which
reflects the total actual spending, and I can't seem to get it
accomplished......I keep getting #Error instead of the figure. If I go into
the subreport, where I've created the total in a text box which I'm trying
to draw into the main report, it runs fine when I run the subreport....I get
the actual spending figure. And I'm pretty sure I've got everything right
(but obviously not) in the text box on the main report:

=[subreportname].[report]![name of text box in subreport]

Can anyone explain what is wrong and how to get a total from a subreport
into a main report. I've looked in the KB and see that if there's no data
you'll get this error, but I do actually have data so a amount should be
showing up.

Any help greatly appreciated.....thanks,
Bob

Reply to this Message

Seth Schwarm - 26 Oct 2005 01:43 GMT

Bob:

I think I have had a similar situation myself, in the past.

I am assuming your report only has one subreport.

Let's call the field you want to tally: MyBills

You will place a text box in either the Report footer or perhaps the next
interior level's footer. Its control source should be: =Sum([MyBills])

Then format the field to your desire.

My experience has been that when you attempt to sum a calcuated field from
subreports, bad things happen.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

The important thing here is that you place the new text box in the
appropriate footer. Only you can determine which footer that is. If you are
not familar with what I am talking about, it is included in Sorting and
Grouping.

Best luck,

Seth

> I am trying to create a financial report that compares planned spending
> against actual spending. Actually, I have the report basically done--using
[quoted text clipped - 18 lines]
> Any help greatly appreciated.....thanks,
> Bob

Reply to this Message