Crystal Reports Question

powerman

Gawd
Joined
May 21, 2002
Messages
562
I am trying to make a Crystal Report for a fruit database. I would like to have an If statement in my report to check a value of a field in my database and display a result based upon the field. Here is a quick simplified example of what I am trying to do. I have a table named Fruit in my database and fields named fruit and number. The table looks like this:

Fruit Number
Apples 7
Oranges 0
Pears 1

I want my report to change all the zeros to "Out of Stock". So the report would look like this:

Fruit Number
Apples 7
Oranges Out of Stock
Pears 1

Any ideas on how to do this? I am new to Crystal Reports so I would appreciate any help. Thanks for your post.
 
Back
Top