Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Uppercase formula Post Reply Post New Topic
Author Message
crystalhelp
Newbie
Newbie


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


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
crystalhelp
Newbie
Newbie


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


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
crystalhelp
Newbie
Newbie


Joined: 22 Dec 2011
Online Status: Offline
Posts: 3
Quote crystalhelp Replybullet Posted: 22 Dec 2011 at 10:08am
Thanks! it worked
IP IP Logged
Post Reply Post New Topic
Printable version 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



This page was generated in 0.039 seconds.