Crystal Reports Uppercase formula

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Uppercase formula

Author	Message
crystalhelp Newbie Joined: 22 Dec 2011 Online Status: Offline Posts: 3	Topic: Uppercase formula 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
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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.
	IP Logged

crystalhelp Newbie Joined: 22 Dec 2011 Online Status: Offline Posts: 3	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
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Edited by DBlank - 22 Dec 2011 at 10:15am
	IP Logged

crystalhelp Newbie Joined: 22 Dec 2011 Online Status: Offline Posts: 3	Posted: 22 Dec 2011 at 10:08am
	Thanks! it worked
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum