Preceding Zero Formula for Crystal Report

[goldmine925]

I have a field in report that is supposed to be 10 characters long but most of the values for this field do not meet length. I need to know how to add the preceding zeros to all the fields so the length matches in the report. Any suggestions would be greatly appreciated!

 

[bdreed35]

What is the datatype of the field, string or numeric?

If it is string, then try this:

right("0000000000" & {table.field},10)

if it is a number, then try this:

totext({table.field},"0000000000")

~Brian