Output based on condition

[Zugdud]

Ok im real new to crystal reports, and am trying to output based on a condition. Condition is: If field Character01 is not null print OrderHead.Character01, else print Shiphead.Address

This has got to be real common so mabey im missing something? Can't I just create a formula that will do this?

Thanks for any help

 

[Nellie79]

This is with crystal syntax:

If not(IsNull{OrderHead.Character01})) Then
{OrderHead.Character01}
Else
{Shiphead.Address}

 

[alectek]

If you need 2 of those field be in report:

Right Click on OrderHead.Character01 -> Format Field -> Common tab -> across of Suppress, click on x+2 and type: not isnull(Character01) -> Save

Right Click on Shiphead.Address -> Format Field -> Common tab -> across of Suppress, click on x+2 and type: isnull(Character01) -> Save

You can use very simple formula @OrderOrAddress
If isnull(Character01) then
Shiphead.Address
Else
OrderHead.Character01

Place this formula in details section…should work.

Alik

 

[Zugdud]

Thanks for the follow up guys! I plugged it in and everything worked great! awesome!