Page Numbers.

[BillBee]

I have a page where I have invoked a Force New Page on a Section Header I have set up. When the numbers of the pages appears they are number 1 to 26 through each Section(the whole document) where I would like the page numbers to begin at 1 again for each section. Is this possible and if so can anyone tell me how I must set this up.

 

[stopher]

In the On Format event for the section header you could put the following:
me.page=1

This will reset the page number to 1 at the beginning of each new section.

A more glamourous solution is here which enables you to show page x of y for each section.

Chris

 

[BillBee]

Thanks for reply. That has not worked for me. #1. I never thought it would have a bearing but did not mention in first post that in this case the page is set for columns. They are set to go across and down. When I insert the code it is forcing the content of report to simply go down the page in a single column. #2 On another report no columns it just creates on continous page.

 

[stopher]

I tried to me.page=1 solution and it seems to work fine for me with columns (both across and down).

I've attached a working example. Take a look at Report 1. Note that I've put the code in the Customer Header On Format event.

hth
Chris

 

[BillBee]

Thanks. Will check on my setup of the Design of my form. Suspect the problem may be there.

 

[BillBee]

Sorted problem. Needed to add another group to sort out SectionId from the SectionHeading. Thanks for help