Aug 26

Written by: Steve Gray
8/26/2010 7:36 AM 

This is my second shot at this. I tried just using a formula in the Report Code section, but the formula recalculates if the user pages back and forth. So, part deux:

If you have a number in a data set that exists at a grouping level (like a beginning balance figure on a trial balance) you’ll need ‘running total’ functionality. That’s almost trivial in Crystal Reports, but SSRS hasn’t gotten there yet.

Here’s how to do a running total in SSRS.

Right click in a blank area of the report, choose Properties.

Choose ‘Code’

Add this code to the code window:

Next, add a Report level Variable (we’ll use this in the last step):

 

Then in the group line, add this expression:

I had to change the font color to White to hide the field… not optimal.

Last, in the report footer, add this:

This is a reference to the Variable that we added in step 2

(sigh) Waaay too hard. Microsoft, are you listening?