Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Hiding totals in some cells in Matrix report

  • 24 December 2009
  • Author: ashishnaik1
  • Number of views: 4185
  • 0 Comments

-->

In SSRS 2005, it is challenging to hide some cells when using Matrix report. I was working on one report where I need to show premiums and ratios in matrix report.

Users want to group data at 2 levels (group and sub group) and wants total for each sub group and Grand Total by Group.

 

Since Matrix report was an obvious choice, one challenge was to hide the totals of Ratios columns (as ratio is in percentage, it is non additive). After “Googling”  many web sites and spend considerable amount of time I found a workable solution. I hope this will help to many others.

 

Here is the step by step guide. ( I assume you have already created a DataSet for the report)

 

 

 

Print
Categories: Reporting Services
Tags:
Rate this article:
No rating

ashishnaik1ashishnaik1

Other posts by ashishnaik1

Please login or register to post comments.