Combining Two Address Fields in SSRS w/ Expression -
I am trying to combine two fields in one text box in SSRS through an expression. If there are two entries in an address, then I need a line break between Addr1 and Addr2.
What I currently have:
= Field! Addr1.Value; VBCLLF and amp; Field! Addr2.Value But entry in Addr2 can not be, so I want to handle NULLS effectively.
I tried:
= Field! Addr1.Value & amp; VBCLLF and amp; IIF (IsNothing (Fields! Addr2.Value), "", field! Addr2.Value but it does not appear to be working. How does this suggest? I believe you need to change the order of your conditional combination:
(I think you intend VbCRLF Conditional.)
Comments
Post a Comment