I have a report with to subreports. The subreports are not visible. I have a text field that states:
=([Reports]![rptOverallShippingStats]![subrptOverallShipCompletebyNevada].[Report].[CountofLot]+[Reports]![rptOverallShippingStats]![subrptOverallReShipCompletebyNevada].[Report].[Lots])/[Reports]![rptOverallShippingStats].[Report].[OverallNevadaLots]
The subreport OverallReshipCompletebyNevada.Lots is often blank. There are no values. However, I have a text field called Lots in the report that uses the IIf(IsNull) formula and in the subreport I get 0s. However, when I tell the main form to add the value from another subreport (this one is populated) and the reship, I get an error message.
Any ideas?
=([Reports]![rptOverallShippingStats]![subrptOverallShipCompletebyNevada].[Report].[CountofLot]+[Reports]![rptOverallShippingStats]![subrptOverallReShipCompletebyNevada].[Report].[Lots])/[Reports]![rptOverallShippingStats].[Report].[OverallNevadaLots]
The subreport OverallReshipCompletebyNevada.Lots is often blank. There are no values. However, I have a text field called Lots in the report that uses the IIf(IsNull) formula and in the subreport I get 0s. However, when I tell the main form to add the value from another subreport (this one is populated) and the reship, I get an error message.
Any ideas?
