troubleshooting Question

How to calculate the Max() of a (totals) row in a Matrix report

Avatar of Steve7423
Steve7423Flag for Canada asked on
Microsoft SQL ServerMicrosoft SQL Server 2008SSRS
5 Comments1 Solution302 ViewsLast Modified:
I have a Matrix report that counts the items in columns.  The problem is that I need to then get the max() of all the (total) counted items.

Think of a spreadsheet with 30 columns and 20 rows.  Below each column there is a total which counts the number of items in the column.  See the attachement

I’ve found some possibilities using inscope and others using code behind but they all refer to the specific fields, or the max of the items within the columns and this is not what I want.

The problem is that the items in the rows (y) are actual user names and the total at the bottom of the column is a count(fields!User_Name.value).  

The problem is the Max text box must display the max from the row, eg: Max(Count(Fields!User_Name)) but you can’t do that.  

Using the attachment as the example, the Max textbox which contains Max(B12-F12)   :5 is the max of the totals.  I need to display 5 as it’s the largest within the row.
How can I find the Max of the counted values in the total textboxes.

Any and all creative approaches welcomed.
Matrix-Max-Example.bmp
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros