Resetting page numbers

building reports desktopintelligence
1

I am using BO 6.5.4.

I have a report that shows transaction details for customers. The users have requested that the page numbers be reset each time the customer changes.

The report has a section on the customer number and is formatted to start each customer on a new page. Some customer details go over more than one page.

Any help that anyone can give would be greatly appreciated.

Fherry :barbados: (BOB member since 2007-03-21)

2

The only solution that i can remember implementing is


PageInSection()

Format your section so that it shows only one value per page and have this function called within that break. This would work.

boe_bods :india: (BOB member since 2008-03-14)

3

This does not seem to work, or maybe I have misunderstood you.

If I use =PageInSection(), I get an error. The function needs a parameter. If I use =PageInSection(SectionNumber()), the result is ‘1’ on the first page; however, every other page shows ‘0’.

Fherry :barbados: (BOB member since 2007-03-21)

4

Try doing PageInSection(1). Would that work for you?

boe_bods :india: (BOB member since 2008-03-14)

5

This is not perfect. I will have to change the format of the report somewhat; however, it will work.

Thank you for your assistance.

Fherry :barbados: (BOB member since 2007-03-21)