Subreport, Hasdata Function to display No Data Available

[Xeloris]

Guys,

I have a mainreport, that has subreports and when the subreport does not return a value, nothing appears. I would like to keep the header the same and under it say " There were no issues to report"

So after research, i found that i must be using the hasdata function. However after about 6 hours im about ready to shoot myself haha. I can't figure it out.

I am adding a textbox to the subreport, go to properties, and controlsource and placing this code in

IIf([DomainNotables].[Report].[HasData],Null,"There are no issues to Report!!")


After running the report it is now asking me for a parameter value.

Thanks, Josh

 

[apr pillai]

Check the following link for a sample solution:

http://www.msaccesstips.com/2008/09/no-data-and-report-error/

This is for main report but you can implement this method on sub-reports as well.