mark special record

Hi, all,

I am tring to add a special symble for a record if it meets some condition. The result is somehow like this:

apple
# orange
cherry

How can I do that? Thanks

Add a Text Object, enter the desired text and set it's Suppression Formula to something like

{Database Field Name} <> "orange"

Or create a Formula and put it on the report instead of the database field.

Code:

---

If {Database Field Name} = "orange" Then
  "# " + {Database Field Name}
Else
  {Database Field Name}

---

Thanks so much, bruce.