Display keywords instead of integers

问题:

My table returns 1, 2, or 3 for my field. How can I change this in my report to display "active", "inactive", and "lost" respectively?

回答1:

Define a formula named @TagName for example. It contains the following code:

IF {Tag} = 1 Then
  "Active"
Else IF {Tag} = 2 Then
  "Inactive"
ELSE IF {Tag} = 3 Then
  "Lost"
ELSE
  ""

Then use the @TagName field instead of Tag.