• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

Crystal Reports 2008 Formula to Change Field Format

I have a report that has a rate amount field. Depending on what the rate type field is will determine whether the field needs to be displayed as a percent or as a decimal. Example if the rate type = CASE then rate amount needs to be a decimal if the rate type = RATE then the rate amount needs to be a percent. Where and how would I do this kind of conditional formatting in crystal?
0
kcjstarling
Asked:
kcjstarling
  • 2
  • 2
1 Solution
 
peter57rCommented:
I would be inclined to use two copies of the field in this case. Format one as percent and the other as decimal.
Use conditional suppression to suppress the one you don't want to see.
0
 
kcjstarlingAuthor Commented:
But how do I surpress just the feild and not the whole section?
0
 
peter57rCommented:
Right click the field and choose Format field.
On the Common tab click the X+2 button for the Suppress option.

Add your rule here.

(Do the opposite rule for the other copy of the field)
0
 
kcjstarlingAuthor Commented:
Thanks
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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