I have a Matrix Report and I have to replace my values/measures with "x" if the value is Blank Where Rank1 in (1,3,5,7) Talking in terms of SQL, what I want is Set Col1 = 'x' where Col1 IS NULL and Col2 in (1,3,5,7) Suman Gupta

Hello Suman, This is in T-SQL? Then you can use the CASE WHEN statement like this: SELECT CASE WHEN Col1 IS NULL AND Col2 IN (1, 3, 5, 7) THEN 'X' ELSE Col1 END AS myCol1 FROM yourTable ... Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Hello Suman, In the report level, I think that you can rerfer to the following expression to deal with the blank value. Please see: =IIF(Fields!MyField.Value Is nothing, "X", Fields!MyField!Value) If I have someting misunderstood, please point out and elaborate your requirement with more detail. Here is an aricle about expression examples in Reporting Services for your reference, please see: http://technet.microsoft.com/en-us/library/ms157328.aspx Regards, Bin LongBin Long TechNet Community Support