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: 679
  • Last Modified:

Crystal Reports formula to limit column to uppercase

Crystal Reports (Visual Studio):
I need a formula to limit the column below to upper case.
{tblJobOrdersDetail.Manufacturer}
0
dave_sky
Asked:
dave_sky
  • 3
  • 3
1 Solution
 
mlmccCommented:
UCase({tblJobOrdersDetail.Manufacturer})

or

UpperCase({tblJobOrdersDetail.Manufacturer})

mlmcc
0
 
dave_skyAuthor Commented:
I couldn't get it to work:
I used the formula in "Format Editor" > Font

(I tried both examples)

Could a different formula belong in Font Style?
0
 
mlmccCommented:
There is no way to do it that way.

Create a formula and use it instead of the field on the report

mlmcc
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
dave_skyAuthor Commented:
Sorry, How do I Create a formula and use it instead of the field on the report
0
 
mlmccCommented:
Open the report
Display the FIELD EXPLORER
Right Click FORMULAS
Click NEW
Give it a name
Enter the formula

mlmcc
0
 
dave_skyAuthor Commented:
It turned out that I have a problem with visual studio: When text (lower case w/ caps) is *copied and pasted* into a column the procedure interferes with the uppercase code that is in visual studio.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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