Hide Header if its Subreport Has No Records (A2002)

[David]

We have a report that lists employees assigned to each department. The
report is grouped by department name, and contains a department_name header,
which contains a subreport of employees. The main report lists all
departments. Is there a way to hide the department if the subreport contains
no employees for that department? More generally, is there an easy way to
hide a report header if the subreport in that header contains no records,
even when the report header has a record (like a department)?
Thanks for your help,
David

 

[Allen Browne]

Use the HasData property of the report in the subreport.

For example, you could set the Control Source of your text box to:
=IIf([NameOfYourSubreportControlHere].[Report].[HasData], [DeparmentName],
Null)

Be sure to change its Name property as well: Access gets confused if the
text box has the same name as a field, but is bound to something else.

If you need something more powerful, it is possible to programmatically set
the Visible or PrintSection and MoveLayout properties of a section in its
Format event.

 

[David]

Thank you Allen. I'll try your recommendations.

Use the HasData property of the report in the subreport.

For example, you could set the Control Source of your text box to:
=IIf([NameOfYourSubreportControlHere].[Report].[HasData], [DeparmentName],
Null)

Be sure to change its Name property as well: Access gets confused if the
text box has the same name as a field, but is bound to something else.

If you need something more powerful, it is possible to programmatically set
the Visible or PrintSection and MoveLayout properties of a section in its
Format event.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

We have a report that lists employees assigned to each department. The
report is grouped by department name, and contains a department_name header,
which contains a subreport of employees. The main report lists all
departments. Is there a way to hide the department if the subreport contains
no employees for that department? More generally, is there an easy way to
hide a report header if the subreport in that header contains no records,
even when the report header has a record (like a department)?
Thanks for your help,
David