Descending Page Number

[Former Member]

Hi,

I would like to add a descending page number on crystal forms. It need to create a sort field for another program to pick up.

E.g Check number 1000,1001,1002,1004

I would like Check number 1000 to have the largest page number 4, 1001 page number 3, 1002 page number 2, 1004 page number 1.

I will need to keep the print order by Ascending check number.

Thanks,

Debbie

[Former Member]

Thanks Abhilash,

This almost worked. However it is giving me 0,-1,-2,-3 so if I use this field to sort it is still in ascending order. I need the first page to have 3, then 2 then 1 as the field.

Thanks,

Debbie

[abhilash_kumar]

Hi Debbie,

Create a formula with this code and place it on the Page Footer:

shared numbervar x;
if pagenumber = 1 then
TotalPageCount 
else
(
    x := x + 1;
    TotalPageCount - x;
)

-Abhilash