ACCESS FEED: Re: [MS_AccessPros] No Data on Report

Selasa, 21 Oktober 2014

Re: [MS_AccessPros] No Data on Report

you can also try

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)      If Me.subrpt1.Report.HasData = True Then          Me.subrpt1.Visible = False
    Else          Me.subrpt1.Visible =true
      End If  End Sub

On Wed, Oct 22, 2014 at 11:25 AM, Rajiv <torajiv@gmail.com> wrote:

Sarah
If the report and subreport are not linked to each other why not have a report with two subreports instead of a report and subreport?

In the onformat event on the parent report you can use a dcount function to determine the number of records of each report and then make the one with no records invisible.

example
if nz(dcount("[id]","qryOne"),0)=0 then
report1.visible=false
else
report1.visible=true
endif

similarly for second report.

Rajiv

On Wed, Oct 22, 2014 at 5:04 AM, sarahk@schemesoftware.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a report with a subreport. The data for the report and the subreport are coming from 2 different queries. If the report has no data, I would still like to print the subreport. But when I test for no data and cancel the report , it does not print the subreport. How do I do this?.
If I print the report with no data, it looks ugly, because there are '#error's printing on the report.
As always, thanks in advance for your help
Sarah