Solved

Converting Upper Case values to Mixed case using Crystal reports

Posted on 2003-10-31
10
2,378 Views
Last Modified: 2007-12-19
Does anyone know how to convert upper case values to mixed case using crystal reports?  I can't find it anywhere in the functions lists anywhere.  I would appreciate any help.

Thanks,
Barbara
0
Comment
Question by:bgonzales
10 Comments
 
LVL 1

Accepted Solution

by:
merlin5656 earned 500 total points
Comment Utility
There is Proper Case:
In your formula type:
          ProperCase({SCHEMA.FIELD})

This would change     'FIRSTNAME LASTNAME'    to    'Firstname Lastname'



is that what you mean..

0
 

Author Comment

by:bgonzales
Comment Utility
Yes that is what I mean but i did not find any documentation for proper case in crystal reports so I wanted to ask.  I will try this.  Thanks.
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
It only exists in V9.

Pete
0
 
LVL 22

Expert Comment

by:Ido Millet
Comment Utility
For CR 8.5 and earlier, search for and download UFLcaps.exe, on Crystal Decisions web site.
This gived you U2lcaps.dll and Uflcaps.dll which are user function libraries that add the
LeadingCaps() function under Additional Functions in Crystal's formula editor.

Cheers,
- Ido
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:bgonzales
Comment Utility
Thanks for the replies.  We do have version 8.5.

New question:  Has anyone seen the page header or report headers repeating in every row prior to the data?  For example if my report looks like:
  Name      Number
  Barbara   123
  Gonzales 456

When I export it, it looks like:
Name, Number, Barbara, 123
Name, Number, Gonzales, 456
0
 

Expert Comment

by:zoombo
Comment Utility
To what format are you exporting to ? Yes, some of the formats like DIF will produce that kind of results.

-Zoombo
0
 

Author Comment

by:bgonzales
Comment Utility
I've tried all the formats.
0
 

Expert Comment

by:zoombo
Comment Utility
Try exporting to RTF format, I have been using this format to be printing as is.

-Zoombo
0
 

Author Comment

by:bgonzales
Comment Utility
Exporting to the RTF format didn't work so we exported the headings separately from the data.  Thanks for the help!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now