Relative Content

Tag Archive for matrixconditional-statementsformatgrouping

Column Formatting based upon a Group – Even if there is no data in the group

I have report that has formatting on the column in a matrix. I want to column for Total Gross sales to be light grey (=iif(Fields!STATS_GROUP.Value=”GROSS”, “LightGrey”, “Transparent”)) but if there is no data in that column it leaves it white. If I switch the expression. Is there a way to do this in report builder?