Post reply

no wrapping but expanding cell width?

  • November 16, 2010 at 5:21 am

    #226643

    I'm aware of the can grow property, which when set to false forces the data to appear on one line. This is what I want, but I'd like the columns to be wider or narrower to accommodate the data in question. I've had a look around and done a Google search and I couldn't find anything.

    I'm new to using Reporting Services so sorry in advance if this is stupidly easy and I'm missing something obvious!

    Thanks!

  • November 16, 2010 at 11:43 am

    #1251516

    The short answer is that you can't do this in SSRS. The long answer is there is a solution to almost every problem. Take a look at the link below. There are a couple of reasonable approaches with different levels of control and difficulty. The first suggestion is to use multiple columns and hide or show the appropriate length column at runtime with an expression in the Visibility properties of the textbox. The second suggestion is to go directly at the report definition in the report database, and modify the column widths programatically at runtime, just before rendering.

    http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/9e6043f1-c458-4540-be59-d37b02feab8a/

    Good luck, I hope this helps.

  • November 17, 2010 at 2:08 am

    #1251725

    Thanks for the reply Daniel. As I said I'm just getting started with reported services. It's not mission critical that it's the correct width because it gets exported to Excel, its just an irritation. It also seems (from a newbie perspective) strange that it's so simple to prevent or allow the height of the cell to change but not the width. Oh well!

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply