Crystal Reports vb.net Select Expert formula on a field

I have two fields.  Address1 and Address2.
If address1 is blank I would like to show address2 in its place.

mphillip85Asked:
Who is Participating?
 
mlmccCommented:
Use a formula
Name - MyAddress
If (IsNull({Address1Field}) OR ({Address1Field} = "") then
  {Address2Field}
else
  {Address1Field}

mlmcc
0
 
mphillip85Author Commented:
Thanks.  Works Great!
0
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.