Skip to Content
0
Former Member
Jul 21, 2009 at 09:02 PM

Field Selection

20 Views

Fairly new to Crystal, and having a problem selecting fields in a database [ using Crystal XI ]

How do I select fields using several criteria, but embedded in an if statement? All fields are in the same table.

Example:

If cost = 0 from (location 4000, cost type "Standard",)

then select cost from (location 4060, cost type "Standard)

else ""

Can this be done under the Select Expert, or does it need to be done under Formula Editor?

Many thanks

Andy