I have a report that contains a subreport. When the subreport does not have any data to display I would like a label to appear with a message saying "No New Clients". I have the label on the subreport with the visible property set to false. I also have the below code. This works when I run the subreport separately, but when I run it with the main report it does not work. Any suggestions?
Private Sub Report_NoData(Cancel As Integer)
Me.lblNNC.Visible = True