Sub-report not showing in main report

[Jeff S via AccessMonster.com]

I have a report based on a query that displays 3 fields. 1 is a number of
items produced (A), the next is number of items destroyed (B). The last field
(C) is calculated based on the 2 previous fields: it s the % of compliance 1-
(B/A) (# of destroyed/ # of produced).
The problem is that when A is null the query returns nothing so the report is
blank.
To address this issue, I made a test that display 100% in the report when B
is null:
=IIf( Is Null,1,1-(B]/[A]))
When I launch the subreport by itself it shows the value 100%
However when I integrate this report as a subreport in a main report, the
value 100% does not show (the report is blank!

Please help!

Jeff

 

[Jeff S via AccessMonster.com]

I have a report based on a query that displays 3 fields. 1 is a number of
items produced (A), the next is number of items destroyed (B). The last field
(C) is calculated based on the 2 previous fields: it s the % of compliance 1-
(B/A) (# of destroyed/ # of produced).
The problem is that when A is null the query returns nothing so the report is
blank.
To address this issue, I made a test that display 100% in the report when B
is null:
=IIf( Is Null,1,1-(B]/[A]))
When I launch the subreport by itself it shows the value 100%
However when I integrate this report as a subreport in a main report, the
value 100% does not show (the report is blank!

Please help!

Jeff

Sorry I meant when B is null not A!!