Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3171
  • Last Modified:

UpperCase report

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
mcs1169
Asked:
mcs1169
  • 2
1 Solution
 
GizaCommented:
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
 
GizaCommented:
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
 
mcs1169Author Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now