Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Big problems, disguise big opportunities
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Display a Field with a Fixed Number of Characters in Crystal Reports?

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.


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


Name *

Email Address *

Comment *

To prove you are human what is:

53 + 66 =