Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Genius begins great works; labour alone finishes them
 
Joubert
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!!!!

28
July

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.


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

MAKE A COMMENT

Name *

Email Address *

Comment *