How to fix the width of a tablix in SSRS - Denali
Is there any way to prevent a column from expanding in width in SSRS(SQL Server 2012)? Ive set the CanGrow property to true to allow the height to increase. But instead of making longer strings multi-line, the width of the column increases. The column contains URLs(no spaces). It displays correctly in the preview but not on the browser(IE9 and Firefox). Thanks, Deepti
June 7th, 2012 5:16am

Hi Deepti, In Reporting Services, the column width that we specify in the report designer doesnt work when a report is rendered into HTML format. This is by design. Based on your scenario, you can render the URLs as HTML hyperlinks. In this way, the length of the URL will be reduced and so is the column width on the HTML Viewer. For more information, please see: Formatting Text and Importing HTMLHow to: Add HTML into a Report Personally, I recommend you that submit this suggestion at https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to add the feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided. Thanks for your understanding. Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2012 11:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics