How to compare two string columns in SSRS?

• kish1234

  Ten Centuries

  Points: 1112

  More actions

  March 20, 2014 at 1:46 am

  #289611

  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 TRIM((Fields!Column A.Value)= TRIM (Fields!Column B.Value),Fields!Column A.Value + " { " + Fields!Column B.Value + " } " , Fields!Column A.Value)

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

  Thanks

  Krishna.

• Paul Keys

  SSC Eights!

  Points: 866

  More actions

  March 20, 2014 at 2:13 am

  #1698584

  Hi,

  If you change + to & this should work. & is used in ssrs expressions for combining strings