Combining Two Address Fields in SSRS w/ Expression

Question

I'm trying to combine two fields into one text box in SSRS through an expression. If an address does have two entries, I'd like a line break between Addr1 and Addr2.

What I have currently is:

=Fields!Addr1.Value & VbCRLF &
Fields!Addr2.Value

But Addr2 may not have an entry so I'd like to be able to handle NULLS effectively.

I've tried:

=Fields!Addr1.Value & VbCRLF &
IIF(IsNothing(Fields!Addr2.Value),"",Fields!Addr2.Value

But that doesn't seem to work. Any suggestions on how to handle this?

Thank you, that works. Can't mark your comment as the correct answer, but that was it. — MISNole, Jan 22 '15 at 18:25

score 1 · Accepted Answer · answered Jan 22 '15 at 18:26

1

I believe you just need to change the order of your conditional concatenation:

=Fields!Addr1.Value & IIF(IsNothing(Fields!Addr2.Value),"",VbCRLF & Fields!Addr2.Value)

(I think you intended the VbCRLF to be conditional.)

answered Jan 22 '15 at 18:26

Lynn Crumbling

12,985
8
57
95

Combining Two Address Fields in SSRS w/ Expression

1 Answers1