Subreport with no data interfering with calculated control

[Guest]

hi there,
I have a report which contains several subreports. If the report has no
data I have used an IIF statement to set the label to Null
(=IIf([Materialsinfo_subreport].[Report].[HasData],"Materials",Null))
I have a calculate total on the bottom the calculates all subtotals on the
subreports. It works alright, until one of my subreports has no data, then I
get an error message.
Thoughts?
Thanks
Todd

 

[Marshall Barton]

I have a report which contains several subreports. If the report has no
data I have used an IIF statement to set the label to Null
(=IIf([Materialsinfo_subreport].[Report].[HasData],"Materials",Null))
I have a calculate total on the bottom the calculates all subtotals on the
subreports. It works alright, until one of my subreports has no data, then I
get an error message.

The main report text boxes that display a subreport total
need to use the same kind of expression that you used for
the "label".

=IIf([Materialsinfo_subreport].[Report].[HasData],[Materialsinfo_subreport].[Report].total,0)