Hi rhythmk,

in front i can use the expression statement in properties for the matrix data and include formula like =iif(Fields.ProjectValue = "Project 1","Red",iif(Fields.ProjectValue = "Project 2","Blue",...)

If i get a new...

Hi Anthony,

i have been able to perform the operation. I added a sub query where it retrieves all data from Resource table and i have used it in the where...