Friday, March 23, 2012

Is it possible to display field B if field A is null and vice versa.

Hi all,
I'm new with Crystal Report. Just to ask is it possible for me to display field B if field A is null? And to display field A if field B is null. This is because, in one record, either field A or field B will have the value. Any idea?
Thanx in advance..;)Yes u can

write a formula

if isnull(fieldA) then
fieldB
else if isnull(FieldB) then
fieldA

hope it helps|||or

IIF(Isnull(fieldA),fieldB,fieldA)

No comments:

Post a Comment