Matrix and SubTotal

HI,
I have a matrix and data should look like this
The row groups are Office(Mayor)and county(A and B)and
votecount(Total). The Column groups are Party and Candidate.
Then I have a subtotal on office group.
Any suggestions how can I achieve this in my report?
Mayor Democrat
Total candidate1 Candidate2
A 60 40 20
B 80 30 50
140 70 70
But I get the result like this. I am missing subtotal on Total.
Mayor Democrat
Total candidate1 Candidate2
A 60 40 20
B 80 30 50
70 70Hi,
Did I ask wrong question? Let me know so that I can make
correction.Please some one help me out.
thanks.
rb
rb wrote:
> HI,
> I have a matrix and data should look like this
> The row groups are Office(Mayor)and county(A and B)and
> votecount(Total). The Column groups are Party and Candidate.
> Then I have a subtotal on office group.
> Any suggestions how can I achieve this in my report?
> Mayor Democrat
> Total candidate1 Candidate2
> A 60 40 20
> B 80 30 50
> 140 70 70
> But I get the result like this. I am missing subtotal on Total.
> Mayor Democrat
> Total candidate1 Candidate2
> A 60 40 20
> B 80 30 50
> 70 70

matrix

Hello,
I have a matrix on a report with an underlying data set of 15 fields.
When the report viewer exports to HTML with Office Web components,
they can only access fields that have been added to the matrix layout.
Is there a way to make all fields of the underlying dataset available
to the viewer without adding them all to the matrix layout?
Thank you in advance for any help.
CraigNot that I am aware of.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig" <canei32@.hotmail.com> wrote in message
news:9ef7792a.0408260617.7f345e3d@.posting.google.com...
> Hello,
> I have a matrix on a report with an underlying data set of 15 fields.
> When the report viewer exports to HTML with Office Web components,
> they can only access fields that have been added to the matrix layout.
> Is there a way to make all fields of the underlying dataset available
> to the viewer without adding them all to the matrix layout?
> Thank you in advance for any help.
> Craig