Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Forget the Joneses
 
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!!!!

30
November

How Do I Display a Number as the Same Number of Characters in Crystal Reports?

Over the last couple of weeks I have had a number of clients asking "How Do I Display a Numerical value in a field as the same number of characters?" in various versions of Crystal Reports

Solution:

Crystal Reports has a function called ReplicateString, that allows deisgners to display the value in a numerical field as the same number of characters.

This function has 2 arguments:
  • str -The text string to be replicated.
  • #copies - The whole number representing the number of times str is to be replicated.


Example:

ReplicateString(Chrw(0098), {Tablename.Fieldname})


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 *