Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Formatting Mixed Case or cAmEl Case Post Reply Post New Topic
Author Message
lande76611
Newbie
Newbie
Avatar

Joined: 18 Jun 2013
Location: United States
Online Status: Offline
Posts: 2
Quote lande76611 Replybullet Topic: Formatting Mixed Case or cAmEl Case
    Posted: 19 Jun 2013 at 2:58am

I want names names to appear as they are entered into our system. For instance I want McMan to print as entered, but Crystal 9 seems to only have options for proper case uppercase and lowercase. Right now, all the names that my report generates are being converted to lowercase.

How do I get text to appear as camel case/mixed case?
 
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 19 Jun 2013 at 3:06am
Hi

To test can you crete a text object formula and place in your report and see

Ex : create formula test
"McMan"

Save and place on your report and see how it is printing.

If this works then create a formula for name like

Totext({fieldname}) and place this in report.
Thanks,
Sastry
IP IP Logged
lande76611
Newbie
Newbie
Avatar

Joined: 18 Jun 2013
Location: United States
Online Status: Offline
Posts: 2
Quote lande76611 Replybullet Posted: 19 Jun 2013 at 3:21am
Currently I have Names formatted in the Formula Editor as:
trim({Patient.Lastname}) + ", " + trim({Patient.Firstname})
-----------------
The only Strings functions I see for case are upper, lower and proper. Can anyone tell me a formula I can use for mixed case? Or really, a formula I can use to have Crystal not change the case? The names are (usually) entered into our system correctly.
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.033 seconds.