Skip to Content
0

Serial Numbers: Going up from 00001

Mar 15, 2017 at 04:44 PM

26

avatar image

Hello,

I need a way to create serial numbers for part labels. It would start with 00001 or something similar and increase by 1. I have never found a way to get this done in Crystal Reports V.14.

If there is no way to do it within CR V.14, I'd like to know if there is a SAP plug-in or other application that works with CR V.14 to get it done.

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ian Waterman Mar 15, 2017 at 05:03 PM
0

You can use a variable

@SerialNo

whileprintingrecords;

global numbervar serial:=serial+1;

Totext(serial, '00000', 0, "")

Place this in details and it will increment by one for each detail.

Ian

Share
10 |10000 characters needed characters left characters exceeded
Vitaly Izmaylov
Mar 15, 2017 at 05:06 PM
0

Try the following formula in Details section:

WhilePrintingRecords;
numbervar n;
n:=n+1;
totext(n,"00000")

Share
10 |10000 characters needed characters left characters exceeded
Brian Dong Mar 15, 2017 at 05:06 PM
0

Hi Greg,

Crystal can't store numbers. I have a Control Table that contains my current number for each part. I have a Store procedure that accepts the part number and iterations. So if I have to create 5 labels at once, it will increment the number in the Control Table by 5.

Brian

Share
10 |10000 characters needed characters left characters exceeded