String.format expression in C#

sammi taylor

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

sammi taylor12y ago
Thank you. I will try that.
Vulpes12y ago
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.
Vulpes12y ago
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))