Can't seem to fix the column width

I have a matrix report. I put a rectangle with two text boxes - inside
the column group. Works great!
However - now I can't seem to fix the width of the columns. It just
grows and ignores the property. I have tried to set it for each
individual cell in that matrix. And I have tried to specify the size..
Any idea?
ThxI am not sure when the column width grows. Does this happen when authoring
the report or when you render it? Would you please add some more detail
reproduction steps to your description.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407150710.6351cec1@.posting.google.com...
> I have a matrix report. I put a rectangle with two text boxes - inside
> the column group. Works great!
> However - now I can't seem to fix the width of the columns. It just
> grows and ignores the property. I have tried to set it for each
> individual cell in that matrix. And I have tried to specify the size..
> Any idea?
> Thx|||The reproduction step is:
Create a matrix.
Add a field to the column group textbox.
Fix column width - by selecting Cannot Grow.
Fix the Cell width - by selecting cannot Grow.
Works great!
Now add a rectangle inside the column group textbox...
The 'Cannot grow' fails...|||CanGrow only applies to vertical growth, not horizontal growth. However, the
only thing that grows horizontally is autosized images and matrices (per
column group instance).
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407181543.300fff7c@.posting.google.com...
> The reproduction step is:
> Create a matrix.
> Add a field to the column group textbox.
> Fix column width - by selecting Cannot Grow.
> Fix the Cell width - by selecting cannot Grow.
> Works great!
> Now add a rectangle inside the column group textbox...
> The 'Cannot grow' fails...

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).