Selasa, 21 Oktober 2014

Re: [MS_AccessPros] No Data on Report

 

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

 


__._,_.___

Posted by: Rajiv <torajiv@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar