Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : Truncating text in a column



Vaughan McPherson
6/5/2006 12:00:00 AM
You would think this would be a trivial thing thing to but it does not seem
to be the case. I want to truncate the text at the edge of a column rather
than wrapping it around. Now, I could use the 'right' string function if I
was using a fixed point font but I'm not. Setting the CanGrow property of
the columns to false works when previewing the report in VS but does not
work properly when viewing the report in Internet Explorer, the line is
still wrapped and is partially visible. Am I missing anything obvious ?



petery NO[at]SPAM online.microsoft.com (
6/6/2006 3:30:08 AM
Hello Vaughan,

I was able to reproduce the issue on my side. This behavior seems to be by
design and currently I wasn't able to find other workaround.

As you mentioned, since you use proportional font, expression such as
=Left(Fields!MyField, 25) does not help under the sitaution.

Please rest assured your feedback on this has been routed to the proper
channel. In the meantime, I also encourage you submit via the link below

http://lab.msdn.microsoft.com/productfeedback/default.aspx

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

AddThis Social Bookmark Button