Page Numbering... 1

[sam1one]

Hello:

How does one number the pages differently in a cross-tab report, so that in each pane, another page # comes up.

i.e. if we are counting the pages horizontally, page 1 is on the left and as we go left to right, the page #'s increase in sequential order, page 1 of 3, page 2 of 3, page 3 of 3 horizontally.

Thanks

 

[lbass]

If you have CR XI, there is a horizontal page number found in "special fields" in the field explorer that you can add.

-LB

 

[sam1one]

How about if I have CR 10?

How can I make this (below) formula work on the page # field, I have been able to make it work in the column field, so as to number 1 of 3, 2 of 3 and 3 of 3 (even with the dashes is fine as 1-1, 1-2, 1-3

Thanks

global numbervar PageNum;
PageNum:= PageNum + 1;
if PageNum > 1 then "Page # " + totext(pagenumber,0) + "-" + totext(PageNum - 1,0)
else "Page # " + totext(pagenumber,0)


P.S. When I insert this formula into the formula editor of the page # field, it only gives me Page # 1 all the way across.

 

[lbass]

Please see thread767-1182700 for a method for adding page numbers to virtual pages. I did not try to do Page N of M, however, with this.

-LB

 

[sam1one]

Thanks LB, but this formula below did not work, it yielded only a digit of 1 in the first of the virtual pages.

{@pageno}:

whilereadingrecords;
numbervar col;
stringvar x;
numbervar i;
numbervar pageno;

if instr(x,totext({table.number},"000")) = 0 then (
x := x + totext({table.number},"000") + ", ";
col := col + 1
);
for i := 0 to 30 do(
if col in (5*i)+1 to 5*(i+1) then
pageno := i - 1
);
"Page: "+totext(pageno+2,"00")

 

[lbass]

It worked when I tested it, so that suggests you did not implement it correctly. Please reread the thread and make sure you follow each step. The formula does not stand alone, but must be used in a separate crosstab, for one thing.

-LB

 

[sam1one]

Thanks LB, I got it to work!

Sam