if {AST_Asset.Asset_ID_} like ["*LAB*", "*SIGNUP*", "*QDISPLAY*", "*PUB*"] then "Public" else if {AST_Asset.Department} = "Library" and {AST_Asset.Asset_ID_} like ["*LAP*"] then "Public?" else "Not Public" I am trying to write an expression for this. Any help.

Should it be LIKE or equal? Check SSRS expressions and scroll down to IIF section. So, I think it may be nested IIF =IIF(Fields!Asset_ID.Value LIKE "*LAB*" OR Fields!Asset_ID.Value LIKE "*SIGNUP*" OR ..., "Public", IIF(Fields!Department.Value = "Library" and Fields!Asset_ID.Value LIKE "*LAP*", "Public?", "Not Public")) Alternative solution will be to include this logic into the query directly that returns the data for the report and have PublicInfo field which you construct using CASE function logic. Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog

In addition you could use SWITCH operator - Expression Examples (Report Builder 3.0 and SSRS)Sergei