Menu
I'm working on a tablix in SSRS 2008 and want my columns to autosize (width only) to their contents. CanGrow only affects height. Is there a property I'm missing or any way to otherwise rig the columns to do this?
829
If you want to change column width dynamically, you could try the workaround in this article: SSRS Column Width Auto Size. But your requirement that make the column width reference to a field value returned in dataset cannot be achieved right now. If you still have any question, please feel free to ask.
SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage paginated reports.
Select one cell in a row , go to properties, go to size, give width and height and dis-select "allow textbox height to increase" and "allow textbox height to decrease" in textbox properties. Then it will effect on whole row. Show activity on this post. You can edit the RDL(C) and set it exactly using an XML editor.
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/
57
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
