I have a report that is by "agent". The whole report is 100 pages long. I have page breaks by "agent" so we can distribute each agent's section to him/her separately. So, for example, the first agent's section is only 1 page so the page number should be Page 1 of 1. The second agent's section is 5 pages so the page number should start over for him, Page 1 of 5, Page 2 of 5 and so on. If I just use the regular "Page <TABPAGENO of <TABLASTPAGE", it just numbers them Page 1 of 100, Page 2 of 100 and so on.

Does anyone know if this is possible to do?

Thanks for any and all help

Krysti

ON|BY} fieldname PAGE-BREAK REPAGE

The REPAGE will not reset the total number of pages but consider the following:

DEFINE FILE CAR
COUNTER/I5 WITH BODYTYPE = IF COUNTRY NE LAST COUNTRY THEN 1 ELSE
IF COUNTER GE &LNE THEN 1 ELSE COUNTER + 1;
PAGENO/I5 WITH BODYTYPE = IF COUNTRY NE LAST COUNTRY THEN 1 ELSE
IF COUNTER EQ 1 THEN PAGENO + 1 ELSE PAGENO;
END
TABLE FILE CAR
HEADING
"THIS IS PAGE <TABPAGENO OF <MAX.PAGENO "
SUM MAX.PAGENO NOPRINT BY COUNTRY
PRINT RCOST BY COUNTRY PAGE-BREAK REPAGE
BY PAGENO NOPRINT PAGE-BREAK
BY CAR BY MODEL
BY BODYTYPE
END
-RUN

Hi Jimster,

Thanks for getting back to me so quickly and sorry it took so long to get back to you. I got caught up in some other stuff and just finally had a chance to get back to this.

It seems we're on the right track, but what is &LNE?

Thanks so much for your help!

Christy

&LNE is lines per page.

Am I supposed to set it as something?

Set it to how many lines you want per page: eg -SET = 55; where the hyphen is in position 1.

Better
-SET &LNE = 55;

Thanks Jim, works great! Just one more small question. For some reason there are extra spaces:

Page 1 of 1

instead of:

Page 1 of 1.

People are really picky here. Have you come across this and know a way to fix it?

Your example got squeezed but I think I understand the question.
What is the output format you are using? Also platform.
When I execute in WF to HTML there is no issue.