Subreport page header labels don't repeat

[malibu65k]

Hi All,

I'm not sure if this is possible; I have 2 subreports in a report, neither of the labels in the page headers repeat on the following pages.

I had the labels in the subreports and they worked ok when I ran them by themselves then I placed the subreports in the main report, then they didn't show up at all, even on the first page. I've moved the labels to the main report above the sub reports and they show only on the first page.

Any suggestions...

Thanks!

 

[dhookom]

Open your subreport(s) in design view and add a new highest level of sorting and grouping and set its Field/Expression to a constant like
[tt] =1[/tt]
Choose to display a Group Header for this level to use as a page header. Then set the Repeat Section property to "Yes"
[tt] Repeat Section: Yes[/tt]

Duane
Hook'D on Access
MS Access MVP

 

[malibu65k]

What do you mean by...

add a new highest level of sorting and grouping and set its Field/Expression to a constant like =1


Where do I find this?

 

[dhookom]

Find the sorting and grouping dialog in the design view of the subreport. The top line/level in this dialog should be set to
[tt][blue]
+-------------------------
| Sorting and Grouping
+-------------------------
| Field/Expression |
| =1 |
| |
[/blue][/tt]

Duane
Hook'D on Access
MS Access MVP

 

[malibu65k]

Wow! Awesome! Thanks so much, just what I was looking for. I gave you a star!!!