Matrix column dymamic width

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Matrix column dymamic width

Matrix column dymamic width

Rate Topic

Display Mode

Topic Options

Author

Message

dva2007

Posted Monday, October 01, 2012 5:28 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:05 AM
Points: 530, Visits: 1,020

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

Daniel Bowlin

Posted Monday, October 01, 2012 7:19 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:49 AM
Points: 2,672, Visits: 2,417

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 »

Permissions