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

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.

Thanks

Got it to work