Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Excellence can be obtained if you care more than others think is wise, risk more than others think is safe, dream more than others think is practical, expect more than others think is possible
 
Unknown
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 *

To prove you are human what is:

1 + 96 =