cancel
Showing results for 
Search instead for 
Did you mean: 

Report Page number as an alpha character

Former Member
0 Kudos

Hi Guys

I'm new to Crystal and now need to design a mail merge with a letter with 7 pages, in this I need to create a barcode which will have a sequence of alpha characters A-Z repeating through the whole final document? I'm using SAP Crystal Reports 11.

Can anyone shed any light on this.

Thanks

Una

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Una,

Try this.

Create a formula @page like this.

if pagenumber in 1 to 26

then CHR (pagenumber + 96)

else ''

Former Member
0 Kudos

The above formula will give alphabets upto 26 pages after that you will get blank .

To get alphabets continued again after 26 pages use this formula instead of above one.

Local NumberVar x:= remainder (pagenumber- 1 , 26) + 1 ;

CHR (x + 96)

Former Member
0 Kudos

Hi Vissu

Thanks so much, it was wreaking my head.

Una

Answers (0)