Reporting subreport total on main report

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

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.

I just use

=[subreportname]![name of textbox in subreport]


Make sure that for subreportname, you use the name of the subreport
control on the main form, which is not necessarily the name of the subreport
itself.

Tom Lake

Is subreportname the name of the control or the name of the subreport? Is
the text box that references the subreport in the same section of the report
as the subreport?

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
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

Subreportname is the name of the subreport.
The control in the subreport is in the report footer; the text box
referencing it in the main report is also in the report footer.

Thanks,
Bob


"Duane Hookom" wrote in message
...
Is subreportname the name of the control or the name of the subreport? Is
the text box that references the subreport in the same section of the
report as the subreport?

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
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

What is the name of the subreport control? This might not be the same as the
subreport name.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Subreportname is the name of the subreport.
The control in the subreport is in the report footer; the text box
referencing it in the main report is also in the report footer.

Thanks,
Bob


"Duane Hookom" wrote in message
...
Is subreportname the name of the control or the name of the subreport? Is
the text box that references the subreport in the same section of the
report as the subreport?

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
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

Here's all the actual names:

Main Report: rptSpendplan-to-SpendingComparison
SubReport: qrySpending subreport
Control Name in report footer of subreport: SpendingTotal ; which is:
=Sum([Total])
TextBox in report footer of main report: TotalSpent ; which is:
=[qrySpending subreport].Report!SpendingTotal

Thanks,
Bob


"Duane Hookom" wrote in message
...
What is the name of the subreport control? This might not be the same as
the subreport name.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Subreportname is the name of the subreport.
The control in the subreport is in the report footer; the text box
referencing it in the main report is also in the report footer.

Thanks,
Bob


"Duane Hookom" wrote in message
...
Is subreportname the name of the control or the name of the subreport?
Is the text box that references the subreport in the same section of the
report as the subreport?

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
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

Several times you have provided the name of your subreport and never
suggested that you knew there is a difference between a subreport control
name and a subreport name.

If your subreport control has the same name as your subreport and the
subreport control and [TotalSpent] text box are in the same section of the
main report and there are records in the subreport, then you should not be
getting an error.

You may need to compile and repair & compact. If that doesn't work, try
replacing the existing subreport with a subreport and a single text box that
you can try pull a value from. Otherwise you can start from scratch on the
main or subreport.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Here's all the actual names:

Main Report: rptSpendplan-to-SpendingComparison
SubReport: qrySpending subreport
Control Name in report footer of subreport: SpendingTotal ; which is:
=Sum([Total])
TextBox in report footer of main report: TotalSpent ; which is:
=[qrySpending subreport].Report!SpendingTotal

Thanks,
Bob


"Duane Hookom" wrote in message
...
What is the name of the subreport control? This might not be the same as
the subreport name.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Subreportname is the name of the subreport.
The control in the subreport is in the report footer; the text box
referencing it in the main report is also in the report footer.

Thanks,
Bob


"Duane Hookom" wrote in message
...
Is subreportname the name of the control or the name of the subreport?
Is the text box that references the subreport in the same section of
the report as the subreport?

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
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

Well, ok then, from your response maybe I don't know what the control is
after all. I guess this'll probably sound pretty dumb, then, but I thought
it was the name of the text box I had created in the report footer of the
subreport.....i.e. the text box named "TotalSpent", the result of which I'm
trying to bring across to the main report. Sorry about that. So, then,
what would the control be in this scenario?

Thanks again,
Bob


"Duane Hookom" wrote in message
...
Several times you have provided the name of your subreport and never
suggested that you knew there is a difference between a subreport control
name and a subreport name.

If your subreport control has the same name as your subreport and the
subreport control and [TotalSpent] text box are in the same section of the
main report and there are records in the subreport, then you should not be
getting an error.

You may need to compile and repair & compact. If that doesn't work, try
replacing the existing subreport with a subreport and a single text box
that you can try pull a value from. Otherwise you can start from scratch
on the main or subreport.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Here's all the actual names:

Main Report: rptSpendplan-to-SpendingComparison
SubReport: qrySpending subreport
Control Name in report footer of subreport: SpendingTotal ; which is:
=Sum([Total])
TextBox in report footer of main report: TotalSpent ; which is:
=[qrySpending subreport].Report!SpendingTotal

Thanks,
Bob


"Duane Hookom" wrote in message
...
What is the name of the subreport control? This might not be the same as
the subreport name.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Subreportname is the name of the subreport.
The control in the subreport is in the report footer; the text box
referencing it in the main report is also in the report footer.

Thanks,
Bob


"Duane Hookom" wrote in message
...
Is subreportname the name of the control or the name of the subreport?
Is the text box that references the subreport in the same section of
the report as the subreport?

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
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

When you add a subreport to a main report, the subreport CONTROL has a name.
This name may or may not be the name of the subreport. Just like if you add
a label or text box to a report, the control has a name. Your subreport
control name may be the same as its Source Object property.

If you look at the Catalog report in Northwind.mdb, it has a subreport
control named "CatalogSubreport" and the Source Object is the "Catalog
Subreport".

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Well, ok then, from your response maybe I don't know what the control is
after all. I guess this'll probably sound pretty dumb, then, but I
thought it was the name of the text box I had created in the report footer
of the subreport.....i.e. the text box named "TotalSpent", the result of
which I'm trying to bring across to the main report. Sorry about that.
So, then, what would the control be in this scenario?

Thanks again,
Bob


"Duane Hookom" wrote in message
...
Several times you have provided the name of your subreport and never
suggested that you knew there is a difference between a subreport control
name and a subreport name.

If your subreport control has the same name as your subreport and the
subreport control and [TotalSpent] text box are in the same section of
the main report and there are records in the subreport, then you should
not be getting an error.

You may need to compile and repair & compact. If that doesn't work, try
replacing the existing subreport with a subreport and a single text box
that you can try pull a value from. Otherwise you can start from scratch
on the main or subreport.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Here's all the actual names:

Main Report: rptSpendplan-to-SpendingComparison
SubReport: qrySpending subreport
Control Name in report footer of subreport: SpendingTotal ; which is:
=Sum([Total])
TextBox in report footer of main report: TotalSpent ; which is:
=[qrySpending subreport].Report!SpendingTotal

Thanks,
Bob


"Duane Hookom" wrote in message
...
What is the name of the subreport control? This might not be the same
as the subreport name.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Subreportname is the name of the subreport.
The control in the subreport is in the report footer; the text box
referencing it in the main report is also in the report footer.

Thanks,
Bob


"Duane Hookom" wrote in message
...
Is subreportname the name of the control or the name of the
subreport? Is the text box that references the subreport in the same
section of the report as the subreport?

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
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

Ok, thanks, same thing here then......the name of the subreport and the name
of the control on the main report for that subreport have the same name. I
guess I'm back to square one then.....sounds like what you're saying is that
this really "should" be working but for some reason is not......compiling
and repairing did not produce anything positive, so I guess I'll recreate
them from scratch and see if that helps.

The only thing I see in what you've said in your last response is that the
subreport control and the "TotalSpent" text box are not in the same section
of the main report. The control is in the Detail section (because I want
the spending figures to immediately follow the planned spending line item
against which those dollars are being spent), and the TotalSpent textbox is
in the Report Footer (because I want a Grand Total of all spending, or the
total of all the individual totals throughout the subreport, at the end of
the report. I've actually tried putting them together, though, and although
it doesn't give me the visual presentation I'm looking for, I still get the
#Error.

Thanks for all your help on this,
Bob


"Duane Hookom" wrote in message
...
When you add a subreport to a main report, the subreport CONTROL has a
name. This name may or may not be the name of the subreport. Just like if
you add a label or text box to a report, the control has a name. Your
subreport control name may be the same as its Source Object property.

If you look at the Catalog report in Northwind.mdb, it has a subreport
control named "CatalogSubreport" and the Source Object is the "Catalog
Subreport".

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Well, ok then, from your response maybe I don't know what the control is
after all. I guess this'll probably sound pretty dumb, then, but I
thought it was the name of the text box I had created in the report
footer of the subreport.....i.e. the text box named "TotalSpent", the
result of which I'm trying to bring across to the main report. Sorry
about that. So, then, what would the control be in this scenario?

Thanks again,
Bob


"Duane Hookom" wrote in message
...
Several times you have provided the name of your subreport and never
suggested that you knew there is a difference between a subreport
control name and a subreport name.

If your subreport control has the same name as your subreport and the
subreport control and [TotalSpent] text box are in the same section of
the main report and there are records in the subreport, then you should
not be getting an error.

You may need to compile and repair & compact. If that doesn't work, try
replacing the existing subreport with a subreport and a single text box
that you can try pull a value from. Otherwise you can start from scratch
on the main or subreport.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Here's all the actual names:

Main Report: rptSpendplan-to-SpendingComparison
SubReport: qrySpending subreport
Control Name in report footer of subreport: SpendingTotal ; which is:
=Sum([Total])
TextBox in report footer of main report: TotalSpent ; which is:
=[qrySpending subreport].Report!SpendingTotal

Thanks,
Bob


"Duane Hookom" wrote in message
...
What is the name of the subreport control? This might not be the same
as the subreport name.

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
Subreportname is the name of the subreport.
The control in the subreport is in the report footer; the text box
referencing it in the main report is also in the report footer.

Thanks,
Bob


"Duane Hookom" wrote in message
...
Is subreportname the name of the control or the name of the
subreport? Is the text box that references the subreport in the same
section of the report as the subreport?

--
Duane Hookom
MS Access MVP


"BobV" wrote in message
...
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