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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s