?
Solved

UpperCase report

Posted on 2003-03-18
3
Medium Priority
?
3,138 Views
Last Modified: 2008-02-07
Hello all. I am a Crystal neophyte so please bear with me. We have a need to print a report in all uppercase. I know that there is a function called UpperCase() in Crystal but do not know how to implement it.

The report is already defined and we are trying to change the fields. We are able to chaneg the Header and Footer since they are just text strings and are static but the info returned from the SQL query has us stumped. We have tried a number of things such as:

if {ReqBase.RbTitle} <> " " thenUpperCase ({ReqBase.RbTitle})  

but all we get are "The formula result must be boolean" messages and errors like that.

WTF are we doing wrong??? (I have such a headache from banging my head on the desk).

Thank you in advance.

Mitch
0
Comment
Question by:mcs1169
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
Giza earned 400 total points
ID: 8162573
Why are you using an if function? Just create a formula field with UpperCase({this is my field I want to use}) and when you put the formula field in the place of your regular field it should return all caps.
0
 
LVL 1

Expert Comment

by:Giza
ID: 8162644
Why are you using an if function? Just create a formula field with UpperCase({this is my field I want to use}) and when you put the formula field in the place of your regular field it should return all caps.
0
 
LVL 1

Author Comment

by:mcs1169
ID: 8162673
Giza,

I knew that I making a mountain out of a molehill. I thank you. My head thanks you. My office mates thank you (getting noisy in here with all of that banging).

Mitch
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

765 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