I have a report and on it, a subreport control
Main Report Name: rptInvoiceMain
Sub Report Name: rptInvoiceSubReport
SubReport Control Name: rptInvoiceSubReportCtl
The subreport contains 2 fields - a text field where line items
sold are listed and a currency field where the price per item
is shown. The subreport control displays these two fields
when the main report is opened.
I have a textbox on the main report where I wish to display
the total dollar amount of subreport column #2. Here is my
controlsource property setting for that textbox:
=Sum([Reports]![Orders]![rptInvoiceSubReportCtl].[Report].[ProcFee])
I'm getting an error. What have I done wrong here?