Crystal Reports formula to limit column to uppercase

Crystal Reports (Visual Studio):
I need a formula to limit the column below to upper case.
{tblJobOrdersDetail.Manufacturer}
dave_skyAsked:
Who is Participating?
 
mlmccCommented:
UCase({tblJobOrdersDetail.Manufacturer})

or

UpperCase({tblJobOrdersDetail.Manufacturer})

mlmcc
0
 
dave_skyAuthor Commented:
I couldn't get it to work:
I used the formula in "Format Editor" > Font

(I tried both examples)

Could a different formula belong in Font Style?
0
 
mlmccCommented:
There is no way to do it that way.

Create a formula and use it instead of the field on the report

mlmcc
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
dave_skyAuthor Commented:
Sorry, How do I Create a formula and use it instead of the field on the report
0
 
mlmccCommented:
Open the report
Display the FIELD EXPLORER
Right Click FORMULAS
Click NEW
Give it a name
Enter the formula

mlmcc
0
 
dave_skyAuthor Commented:
It turned out that I have a problem with visual studio: When text (lower case w/ caps) is *copied and pasted* into a column the procedure interferes with the uppercase code that is in visual studio.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.