A client recently asked me "How do I display a field with a fixed number of characters, using leading zeros, in Crystal Reports XI?"
The client needed to display a the contents of the field to always show 10 characters regardless, of how many characters the data had.
For example:
If the field had the value 10111, the formula would display it as 0000010111.
Solution:
Create the formula:
Right('0000000000' &
{tablename.fieldname},10)
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
|
