No Record in Subreport

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have a subreport in my main report. I have a text box in my mainreport
that returns the value of another text box in my subreport. When a record in
my main report does not have a linked record in my subreport, the text box in
my main report returns an Error.

How can I write the formula in the text box in my main report to give me 0
(zero) if there is no matching record in my subreport?

I used "IsNull" in an IIF statement, but it did not work. Any help would be
appreciated.
 
Don said:
I have a subreport in my main report. I have a text box in my mainreport
that returns the value of another text box in my subreport. When a record in
my main report does not have a linked record in my subreport, the text box in
my main report returns an Error.

How can I write the formula in the text box in my main report to give me 0
(zero) if there is no matching record in my subreport?
Click to expand...


=IIf(subreport.Report.HasData, subreport.Report.textbox, 0)
 
Back
Top