Technical Questions: Uppercase formula

Print Page | Close Window

Uppercase formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15222
Printed Date: 04 May 2024 at 12:45pm

Topic: Uppercase formula

Posted By: crystalhelp
Subject: Uppercase formula
Date Posted: 22 Dec 2011 at 8:50am

Hi,

My database returns the patient name in the format 'Joe User' but I need the patient to show as all capitals 'JOE USER'.

I am looking for a formula to get this to work...I already tried

uppercase ({patient name})

and uppercase({patient name}) = uppercase({patient name})

thanks

Replies:

Posted By: DBlank
Date Posted: 22 Dec 2011 at 9:01am

uppercase ({table.patientname}) is correct syntax.

make sure you are creating an a new formula field in the field explorer and using the formula field as your display in the report canvas.

Posted By: crystalhelp
Date Posted: 22 Dec 2011 at 9:33am

Thanks, but when I place this formula above the patient name in the report the patient name remains in the same format. Is there a certain place where this formula needs to be placed?

thanks

Posted By: DBlank
Date Posted: 22 Dec 2011 at 9:58am

in the field explorer

right click on formula fields

select new

enter a name like 'Uppercase Name'

the formula editor opens

add your formula replacing the table.patientname with the your table and field names

uppercase ({table.patientname})

save and close the formula

drag the formula field onto the report canvas on the detail section

use it instead of the actual database field

Posted By: crystalhelp
Date Posted: 22 Dec 2011 at 10:08am

Thanks! it worked

Print Page | Close Window