While fixing the problem described in my previous post I saw lots of people trying to set auto width for the columns. Without any luck though... I have found a way:
- Change Expression to be something like =”<DIV>” & Replace(Fields!YourField.Value," "," ") & “</DIV>”
- Change placeholder properties – General tab – Markup type – HTML-Interpret HTML tags as styles. (Placeholder properties can be accessed by right clicking on Expression (Field) inside of the cell, not on cell itself).
That was too easy :)
PS. Works for SSRS 2008, never tested on 2005.
PPS. Keep in mind - this works ONLY in web browser. Export to PDF and even printing will still use predesigned column width. There might be a workaround too - but I don't really need it, so I will leave it to you guys.
Please comment if you find any additional notes.