Using Like operator and wildcard in SSRS Expression

  • I am relatively new to writing expressions and SSRS. Can someone take a look at my expression and give me some ideas as to how I can accomplish my goal? Thank you in advance. Not too sure wheter or not you can use the 'Like" and Wildcard in the expression..??

  • =Switch (Fields!GLLOB.Value = 'FUEL', “FUEL”, Fields!GLLOB.Value like ‘4%F’, “Frontload”,Fields!GLLOB.Value like ‘4%R’, “Rearload” ,Fields!GLLOB.Value like ‘4%O’, “Open Top” ,Fields!GLLOB.Value like ‘4%N’, “Temp RO” ,Fields!GLLOB.Value like ‘4%D’, “Compactor”, Fields!GLLOB.Value like ‘4%C’, “Compactor” , Fields!GLLOB.Value like ‘4%Y’, “Residential” , Fields!GLLOB.Value like ‘4%X’, “Recycling”, “OTHER”)
  • All figured out

  • Viewing 2 posts - 1 through 1 (of 1 total)

    You must be logged in to reply to this topic. Login to reply