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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s