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