Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Row Group Totals

Author  Topic 

cwildeman
Starting Member

40 Posts

Posted - 2011-03-23 : 14:14:13
Hi,
I am new to SSRS and used the wizard to create a matrix report. My Row groups are Hospital, HacType and HacCategory while my column group is TrxMonth. the detailes section is count(PatAcctNum). I am able to add an overall total for each column but what I want to do is to add a group by total based on Hospital and then an overall total at the bottom. Also, How do I get the row groups to appear in the header section? Right now there is a "merged cell" which is blank above [Hopsital], [HacType] and [HacCateogry].
Thanks,

Chuck W
   

- Advertisement -