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