Friday, January 2, 2015

Crystal Report: Pad a number with leading zeros up to a fixed length

If table.field is a number

ToText({table.field},"00000000")

or

if is a string


Right("0000"&{MyFieldToPad},8)

No comments:

Post a Comment