How to pass to another page when group header change

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marco - 29 Apr 2008 18:23 GMT

Hi. I have a report and in that report I have a group header.

Is it possible to force the the report to start in a new page whenever the
group header change?

Regards,
Marco

Reply to this Message

fredg - 29 Apr 2008 20:04 GMT

> Hi. I have a report and in that report I have a group header.
>
[quoted text clipped - 3 lines]
> Regards,
> Marco

Set that GroupHeader's ForceNewPage property to BeforeSection.
It's located on the Format tab of the GroupHeader's property sheet.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Marco - 30 Apr 2008 09:04 GMT

thanks.

By the way, way the Group Footer of the same group don't repeats on the next
page?

How can I for the page number to change/reset when the group header changes?

Thanks,
Marco

> > Hi. I have a report and in that report I have a group header.
> >
[quoted text clipped - 6 lines]
> Set that GroupHeader's ForceNewPage property to BeforeSection.
> It's located on the Format tab of the GroupHeader's property sheet.

Reply to this Message

fredg - 30 Apr 2008 15:58 GMT

> thanks.
>
[quoted text clipped - 16 lines]
>> Set that GroupHeader's ForceNewPage property to BeforeSection.
>> It's located on the Format tab of the GroupHeader's property sheet.

1) Set the GroupHeader's RepeatSection property to Yes.
It's on the Format tab.

2) See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm

Things to make sure of:

1) Add an unbound control to the Page Footer.
Name this control "ctlGrpPages"

2) Paste the code into the Page Footer Format event.

3) In the code, change Me!Salesman to
Me![Name of the control used to group by]

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message