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.
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)
Other posts by ashishnaik1