Problem with Subreport Totaling

  • Thread starter Thread starter IreneJ
  • Start date Start date
I

IreneJ

Hello,

I have a main report with four subreports. Each one of
the subreports has its total shown on the main report and
then all four are totalled together.

My challenge is with one of the subreports. When you run
the subreport 'Volunteer' by itself it reports a total of
$252.00 in the field that is named
VGAmounttoContractorTotal, but the box that has that name
on the main report shows a total of $162.00. I have
tried everything to see if I had missed something but
can't see it. All four of the subreports have the same
statement in them, it is:
=IIf(Volunteer.Report.HasData,Volunteer.Report!
VGAmounttoContractorTotal,0)

Any help gratefully accepted. Thanks so much,
IEJ
 
I expect you have a Link Master/Child set on the subreport control that
limits the results in the subreport when it is run on the main report.
 
Thank you, actually I have all the four subreports on the
main report and there is no link master/child on any of
them. Each subreport runs off a query that has criteria
lines for a date from frmPrintDialogueBox for
BeginningDate and EndingDate as well as CrewID. All the
subreports are in the Date Footer on the main report with
the subtotals showing under them. Is there always
supposed to be a link master/child on all subreports?

IEJ
 
Setting the Link Master/Child isn't always required. I would check the
control references again.
 
Thank you, can you elaborate a bit, when you say control
references, do you mean the references in the Module? Or
something else.

Thanks again for your help.
IEJ
 
I meant only the control names. You shouldn't have to check references in a
module. I assume you don't have any event code in your report(s).
 
Back
Top