TIL: RunningValue In SSRS

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(Fields!City.Value,countDistinct,Nothing)

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.

Advertisement