Print Page | Close Window

Formatting Mixed Case or cAmEl Case

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19684
Printed Date: 13 Mar 2025 at 2:04pm


Topic: Formatting Mixed Case or cAmEl Case
Posted By: lande76611
Subject: Formatting Mixed Case or cAmEl Case
Date 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?
 


Replies:
Posted By: Sastry
Date 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

Posted By: lande76611
Date 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.


Print Page | Close Window