How to compare two string columns in SSRS?

• kish1234

  Ten Centuries

  Points: 1112

  More actions

  March 20, 2014 at 1:28 am

  #305251

  Hi Team,

  I have a requirement to compare two string columns in SSRS and provide the result as an expression in the reports.

  Requirement is

  If column A = Column B then display column A { Column B } else display only column A

  I have tried this with no luck

  =IIF(Fields!Column A.Value= Fields!Column B.Value,Fields!Column A.Value + " { " + Fields!Column B.Value + " } " , Fields!Column A.Value)

  Note, we have to add trim function to these columns as one of these are user defined. Could you please add this function to the re written script.

  Could some one please post me the script for this requirement.

  Thanks

  Krishna.

• doug.brown

  SSCertifiable

  Points: 5608

  More actions

  March 20, 2014 at 11:03 am

  #1698799

  Duplicate post. See http://www.sqlservercentral.com/Forums/Topic1552885-1633-1.aspx