I created a new SQL Server Reporting Services report for the first time in a long while, and ran into a problem: I have a matrix and want to alternate row color. I’m re-implementing an Excel report using SSRS and want to get the colors right. This report uses a Matrix, so a “row” is a little more complicated than in a normal table.
To do this, I read Ghanesh Prasad’s article on the topic. Of particular interest was his use of the RunningValue function:
RunningValue is a function which I surprisingly never used in my prior SSRS days. It looks extremely useful for building running totals, sub-group calculations, and the like.