Display No Data in the report if the report has no data

[Jblackbelt]

hi all,



i have a report that consists of 7 subreports. If the subreports have no data, the subreports do not show up when printing or in orint preview. Is there a way that if there is no data, I can have it display text in the report such as "No Reviews to Complete as of mm/dd/yyyy?

thanks

[June7]

Example from my db:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.lblOU.Visible = Not Me.ctrOU.Report.HasData
Me.lblCO.Visible = Not Me.ctrCO.Report.HasData
Me.lblRC.Visible = Not Me.ctrRC.Report.HasData
End Sub

[Jblackbelt]

Thanks. that did not end up working for me.

I should also note that individually each report will print out with no data. it is only as subreports that the reports disappear with no data.

In the event there is no data, i would like it to display "No Reviews Due as of MM/DD/YYYY" under each subreport header.

[June7]

AFAIK, can't do that. Subreport has no data it won't show which means labels and unbound textboxes on the subreport won't show either. Only way I could get a message was to put label on main report and code behind the main report.

[Jblackbelt]

Could I embed it in the original report (before I embed it as a sub report)? If so, how would I go about it?

[June7]

A subreport IS embedding on main report. Otherwise, I really don't know what you are asking for.

How many tables are involved in the main and sub form RecordSources? Post the SQL statements.

[Jblackbelt]

I did it a little unconventially. I have a blank report that has one hidden date field. I then drag in 7 reports as "subreports." Essentially there is no "main report" as it is a shell for the 7 subreports to be displayed as one. I'm having trouble getting the SQL statement out of it. They come from 1 table, but several queries.