Crystal Reports Help with formatting text

Technical Questions

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

Topic: Help with formatting text

Author	Message
Jenny Newbie Joined: 11 Jun 2009 Online Status: Offline Posts: 15	Topic: Help with formatting text Posted: 01 Oct 2009 at 8:53am
	Using ProperCase causes data to look like this = Po box and Iii. How do you create data like =PO Box and III.
	IP Logged


BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 01 Oct 2009 at 12:56pm
	This requires a manual formula where you would use a SELECT statement to evaluate special words and format them as you think is best. For example: Select {table.yourfield} Case "po": "PO" Case "ii": "II" Case "iii": "III";;
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

themessenger Groupie Joined: 15 Aug 2008 Location: United Kingdom Online Status: Offline Posts: 48	Posted: 07 Oct 2009 at 4:03am
	In crystal syntax? Just use UCASE: Examples The following examples are applicable to both Basic and Crystal syntax: UCase("Description") Returns "DESCRIPTION". UCase({customer.FIRST NAME}) Returns "RONALD", where {customer.FIRST NAME} contains "Ronald". UCase("Ronald Black") Returns "RONALD BLACK". UCase("abc12345") Returns "ABC12345". UCase("BrEaD " + "AND " + "bUtTeR") Returns "BREAD AND BUTTER".
	Managing Director www.allmymenus.com
	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