May 16, 2008 at 9:43 pm
Hi guys,
I have this problem that is bugging me for quite some time now. I created a matrix report something like this:
Column1 Column2 Subtotal
Row1 Data Subtotal of Data
Row2 Data Subtotal of Data
Row3 Data Subtotal of Data
What I want to do is this:
Column1 Column2 Subtotal
Row1 Data Subtotal of Data
Row2 Data Subtotal of Data
Row3 Data Subtotal of Data
Row4 sum(Data) Sum(Subtotal of Data) <-- Is this possible for matrix reports, if it is how?
May 18, 2008 at 3:41 pm
Don't feel bad... the report designer is a weird beast and things that should be straight-forward seem to be counter-intuitive. You'd think that right-clicking a row handle would present "Subtotal" as an option, but it doesn't. Right click one of the detail row's fixed cells to get subtotals. To get subtotal columns (to the right of a detail set), right click one of the repeating column 'header' cells.
"Professional SQL Server 2005 Reporting Services" published by WROX is a good book to have and explains a lot of this stuff.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply