Subreport with no data interfering with calculated control

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Access said:
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.
Click to expand...


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)
 
Back
Top