String.format expression in C#

Question

Ist expression works for Person Address in string format in my report field, but if there is no Person address, then pull from Location address:

String.Format("{0}, {1} {2}",
Fields!PersonCity.Value,
Fields!PersonStateCode.Value,
Fields!PersonZipCode.Value)

//Modified to add Location address:

String.Format("{0}, {1} {2}",
Fields!PersonCity.Value,
Fields!PersonStateCode.Value,
Fields!PersonZipCode.Value), IIF(IsNothing(Fields!LocationCity.Value,
Fields!LocationStateCode.Value,
Fields!LocationZipCode.Value))

I get BC302015 end of statement expected error.

sammi taylor · Answer

Thank you. I will try that.

Vulpes · Answer

Incidentally if the fields for the report are being pulled directly from a database then you'll need to use the IsDBNull function in place of IsNothing.

Vulpes · Answer

Try this instead: String.Format({0} {1} {2} IIF(IsNothing(Fields!PersonCity.Value) Fields!LocationCity.Value Fields!PersonCity.Value) IIF(IsNothing(Fields!PersonStateCode.Value) Fields!LocationStateCode.Value Fields!PersonStateCode.Value) IIF(IsNothing(Fields!PersonZipCode.Value) Fields!LocationZipCode.Value Fields!PersonZipCode.Value))