Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Matrix column dymamic width Expand / Collapse
Author
Message
Posted Monday, October 1, 2012 5:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, March 8, 2014 5:15 AM
Points: 534, Visits: 1,040
Hi friends,

i am wondering if this is possible. I've set up the matrix to show multiple columns and the number of columns can change from 7, 8 upto 30-40 columns. I've set up the width which works fine for 10-15 columns but some time when i've only 7 columns it looks only half a page rendered. The solution i've used at the moment is 3 matrix and based on numebr of columns in the query it will pupulate different matrix.

If 10 columns then matrix 1 with wide width of column
if between 10-20 columns then matrix 2 with medium width of column
if between 20-30 columns then matrix 3 with small width of column

is it possible to dymically handle the width of the column? i cant put the expression on column width.
Post #1366495
Posted Monday, October 1, 2012 7:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:41 AM
Points: 2,818, Visits: 2,552
Going at it directly with the width property won't work as you have already discovered. The only solution I can come up with is to get very complicated with a lot of hidden/visible expression work for different fixed width columns. The one or two times I have run into this issue I decided the solution was too complicated to persue for the provided benefit.
Post #1366559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse