SSRS tablix column CanGrow property for width?
As mentioned here, an easy fix to this issue is to add a row in your tablix and insert a chart to the corresponding column.
Then change its DynamicWidth
to an expression like the following =iif(True, "4cm", "2cm")
and its DynamicHeight
to "0cm".
I've been trying to do that myself (client side), without success. There is no property that would autosize the column width.
Check out this workaround: http://blog.sharepointalist.com/2009/05/ssrs-column-width-auto-size.html (I haven't tested it)
The best workaround I've found for client side reporting would be to set column's width in code or use multiple columns and show/hide them based on string length condition.
For example, column named AccNum2:
report.DetailSection1.ReportObjects.Item("AccNum2").width = 200
See this thread for details and other ideas: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/9e6043f1-c458-4540-be59-d37b02feab8a/
we can change width dynamically .follow the below steps
step1:add one more column
step2:merge the added columns with original one
step3:add column visibility expression for extra column based on your requirement
still your not getting then see attached picture
The solution from SHOWKATH VALLI worked best for me. An absolute genius idea!
This is how I implemented it:
- Create an additional column to the right of the one you need widening
- Merge the cells
Click on the column visibility of your new column.
Hide/show based upon a calculation or in my case a value in my select statement that this is a wide column.
Here is the expression I created: =IIF(Fields!Static1Wide.Value=0,True,False)