Subreport Error

[IIf Statement Help]

I have a report that contains 2 subreports. The subreports have values that
are used in the report (like an invoice). My problem is that when my
subreport values are null my report calculations show error. How can I fix
this problem?

Van

 

[Allen Browne]

See:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Marshall Barton]

I have a report that contains 2 subreports. The subreports have values that
are used in the report (like an invoice). My problem is that when my
subreport values are null my report calculations show error. How can I fix
this problem?

If the subreport actually has a Null value, then use the NZ
function.

If your problem is that the subreport has no records, then
there is no value, not even Null. In this case you can use:
=IIf(subreport.Report.HasData, subreport.Report.total, 0)