I generally create a primary level sorting and grouping level in the subreports based on a constant expression like:
=1
Display the Group Header for this section. Set this section's Repeat Section property to Yes. Move your controls from the Page Header to the =1 Header.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
I'm not sure I can be more specific. My last comment was "Move your controls from the Page Header to the =1 Header."
I assume you know how to move controls by dragging them. The Page Header section is self-explanatory. The =1 Header is the group header created in the first part of my reply.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
I'm not sure what you mean. If a subreport has nothing in it, this suggests there are no records to display and nothing from the subreport will display in the main report.
The cause for no records to display in a subreport can be traced back to the subreport's record source filtering or the filtering produced by the Link Master/Child properties.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.