Show subreport conditionally

B

Brian

1. How can I show/hide a subreport for just certain records based on the
content of a field on the main report?
2. Some of the records on the main report have corresponding records in the
subreport; some do not. How can I include the subreport for those records
having corresponding subreport data without excluding records from the main
report that do not? The way it is now, as soon as I establish the
master/child link, it excludes from the main report any records not having a
corresponding record in the subreport. I need an "outer join" master/child
link.
 
B

Brian

Never mind.

If <BooleanField> Then
<SubreportName>.Visible = True
Else
<SubreportName>.Visible = False
End If

....and I guess there must have been something else wrong previously, because
it is NOT filtering out records having no subreport data. Fixed now.
 
D

Duane Hookom

If there are no records in a subreport, it won't display. You don't need to
do anything to hide it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top