SSRS – Notes on Adding a Grand Total to a Report with Existing Groups

The trick is that the grand total needs to be the first group. So delete your existing groups, and then add your grand total group first. Then add back in your original groups.

I also set the group on expression to =1 so that it effectively groups on nothing and gives you a grand total over all the rows.

Posted by Greg Pinero (Primary Searcher) on Apr 26th, 2010 and is filed under SQL, win32.

Both comments and pings are currently closed.

Add this post to Del.icio.us - Digg

Comments are closed.