No Data in Subreport

[Castaway4]

I have a report with a subreport.

The problem is if the Subreport has no data I want it to display "There is no Data to Report"

How do i code the report or subreport so that the label appears instead of the subreport just displaying a blank box?

Thanks

 

[Alisa]

I have a report with a subreport.

The problem is if the Subreport has no data I want it to display "There is no Data to Report"

How do i code the report or subreport so that the label appears instead of the subreport just displaying a blank box?

Thanks

Do a search on HasData. You should be able to check the has data property of the subreport, and if it is false, show something else instead.

 

[Castaway4]

Thanks

Got it to work