Share via

Repeat sub-report header

Anonymous
2012-02-06T18:19:02+00:00

I have a report with a sub-report.

On the first page my sub-report's header displays, but it does not repeat the header on any subsequent pages.  How can I set it up so that the sub-report's header repeat on subsequent pages?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2012-02-06T21:59:40+00:00

Create a dummy group header with =1 as expression, and set the Repeat Section of this group header to Yes.

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-02-07T00:53:56+00:00

    With your solution, I was able to google the subject to find more detailed explanation (http://www.tek-tips.com/viewthread.cfm?qid=1578194) and managed to implement it.

    Thank you.

    I don't understand how it works, but it does work.

    QuestionBoy

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-02-07T00:44:59+00:00

    Sorry Hans, but could you explain a little further.

    I opened my sub-report in design mode, I already have 3 groupings in place,  How do I create a bogus grouping exactly?  I can select from the various fields in my underlying query, but how do I create a bogus one like you suggest?

    Thank you for the further explanation.

    QuestionBoy

    Was this answer helpful?

    0 comments