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”)