What I tried: I Sum() the field in the subreports, so I can refer to that field on the main report. However, for the test case I am trying, there are no records for one of the subreports, so I tried:
Expand|Select|Wrap|Line Numbers
- =IIf([PayoutByYrLTTSbRpt].[Report].[NoRecords],0,[PayoutByYrLTTSbRpt].[Report].[LTtotal])
Expand|Select|Wrap|Line Numbers
- =IIf([PayoutByYrLTTSbRpt].[Report].[NoData],0,[PayoutByYrLTTSbRpt].[Report].[LTtotal])
And I also tried :
Expand|Select|Wrap|Line Numbers
- =IIf([PayoutByYrLTTSbRpt].[Report].[HasData], [PayoutByYrLTTSbRpt].[Report].[LTtotal],0)
For the subreport that is giving me trouble, I have :
Expand|Select|Wrap|Line Numbers
- Option Compare Database
- Private Sub Report_NoData(Cancel As Integer)
- Cancel = True
- End Sub