Report Builder

[KarenLim]

HELP!

We are using Report Builder to produce various forms. I am having a major problem with page numbering. We are required to print on each page ..... 1 of 5, 2 of 5, 3 of 5 etc. The reports are grouped by purchase order number and we need this paging technique to reset for each po. Does anyone have any ideas??

Thanks in advance,

Karen Lim

 

[bendaluz2]

If your PO Print has a consistent number of detail lines per page you could do the following:

Make an aggregate expression for a count of the the detail lines reset by purchase order using pre-pass processing. Then create a calculated field, which is the aggregate expression divided by the maximum number of detail lines per page rounded up to the nearest integer. This will give you the number of pages in each PO.

Make another aggregate expression the same as the first, but using final pass processing instead of pre-pass. Create another calculated field the same as before, but using this aggregate expression. This will give you the page number that you are currently on.

If you dont have a consistent number of detail lines per page then you are on your own!

Hope this helps