Home Forums Reporting Services Reporting Services Need help in giving the expression for background color for a column RE: Need help in giving the expression for background color for a column
Ant-Green
SSC Guru
Points: 113445
More actions
January 8, 2013 at 5:25 am
#1574765
Doh moment
LEFT("16",1) = 1 which doesnt match the value as that should go red, do left 2, so change it to CInt(REPLACE(LEFT(Fields!Field.Value,2)," ","")), that way if it picks "1 " or "0 " it will remove the space and do the correct comparission