Cant hide static groups in matrix

I need to make use of static groups for a matrix however I dont want these to
display in the end result. I have hidden them and shrunk them as much as
possible but they still show - even if I put 0 in for the height it comes
back with .03125 in the height of the cell ... it wont allow 0 (in either
height or width). I cant get the same result if I dont add the rows (which
show up as a static group).Here is more info:
I have something like the following set up: Column is Metric Name , Rows
are Level1_Res and Res Name
The intersect is Value and all the other fields are things I need to keep
track of at the Row or Column level.
For each group. Only the Level1_Res level grouping will show at the end
| |
| Metric Name
Level1_ResName | Res Name | Value | value of field
on DB DB | | Rating vs Thres
| set to 1 if threshold is
| | Threshold Level |
MAX(Fields!RVT.Value)
| | MaxEvents
| some expression
All rows except the first are static row groups and I donâ't want to show them
But they are needed for calculations/expressions for other settings I need.
The problem is that column one is taking the height of the entire grouping
(not just the Level1_ResName but all the static rows too) even tho I shrink
them and hide them â?¦ it doesnâ't let me have a height of zero. It is messing
up my matrix â?¦ not to mention when I export to excel *nothing* is hidden
there! And it should be.
"MJT" wrote:
> I need to make use of static groups for a matrix however I dont want these to
> display in the end result. I have hidden them and shrunk them as much as
> possible but they still show - even if I put 0 in for the height it comes
> back with .03125 in the height of the cell ... it wont allow 0 (in either
> height or width). I cant get the same result if I dont add the rows (which
> show up as a static group).