Error when subtotaling from Sub Reports. #Error

[Guest]

I have a financial report which also contains 2 subreports, however when / if
the sub reports do not have any data in them the subtotal line(s) located in
the body of the main report which pull from the sub reports error out
[#Error]. How can I rid the subtotal line(s) of this error message?

 

[Van T. Dinh]

Please post the set-up / expression for the subtotals in the MainReport ...

 

[Guest]

The formula is listed below, but again this error only appears due to the
fact that there are no current records (numbers, values, etc.) available for
the total at the bottom of the report.

=Sum([SumOfRevShare])

Please post the set-up / expression for the subtotals in the MainReport ...

--
HTH
Van T. Dinh
MVP (Access)

I have a financial report which also contains 2 subreports, however when /
if
the sub reports do not have any data in them the subtotal line(s) located
in
the body of the main report which pull from the sub reports error out
[#Error]. How can I rid the subtotal line(s) of this error message?

 

[Guest]

The following is the second (grand subtotal) subtotal on the main report
which pulls from the first total, I believe this one is erroring out because
of the first sub report.

=[Qry_PAYOUT_REVENUESHARE subreport].Report!RevShareTotal

Please post the set-up / expression for the subtotals in the MainReport ...

--
HTH
Van T. Dinh
MVP (Access)

I have a financial report which also contains 2 subreports, however when /
if
the sub reports do not have any data in them the subtotal line(s) located
in
the body of the main report which pull from the sub reports error out
[#Error]. How can I rid the subtotal line(s) of this error message?

 

[Van T. Dinh]

I can't see your database and the names won't help much. You need to
decribe each one of them, whether a particular name is the name of the Field
in the RecordSource of the Report (or SubReport) or the name of the Control
and the ControlSource and the location of the Control (Detial section /
Footer section of the Report / SubReport) if it is a Control.

 

[Guest]

Hi Van,

I was able to eliminate the error message (#Error) by using the following
formula:

IIf([SubReport.Name].HasData=True,[SubReport.Name]!Name&Calculation-Total,0)

Thanks!

I can't see your database and the names won't help much. You need to
decribe each one of them, whether a particular name is the name of the Field
in the RecordSource of the Report (or SubReport) or the name of the Control
and the ControlSource and the location of the Control (Detial section /
Footer section of the Report / SubReport) if it is a Control.

--
HTH
Van T. Dinh
MVP (Access)

The following is the second (grand subtotal) subtotal on the main report
which pulls from the first total, I believe this one is erroring out
because
of the first sub report.

=[Qry_PAYOUT_REVENUESHARE subreport].Report!RevShareTotal