mark special record

[Palmtree]

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

[brucevde]

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.

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

[Palmtree]

Thanks so much, bruce.