MS SSRS tutorial on using expressions to format cells
This is a Microsoft SSRS tutorial video demonstrating how cell formatting can be changed based on an expression. This makes the cell formatting dynamic and changeable depending on values in the report.
This video deals with the following error:
the backgroundcolor expression for the text box has a scope parameter that is not valid for an aggregate function.
Code snippits:
Return sum of all rows: =Sum(Fields!SalesYTD.Value, "DataSet1")
Return count of all rows: =CountRows("DataSet1")
Format based on row average: =IIF(Fields!SalesYTD.Value [greaterthansign] (Sum(Fields!SalesYTD.Value, "DataSet1")\CountRows("DataSet1")), "SlateBlue", "no color")