How to limit the length column in sql server reporting services -
i have table , of cells contain lot of data. want truncate after 10 characters. in design view right clicked column , clicked text box properties unchecked allow height increase. checked preview , fixed problem, after deployed report reporting server length of column increased again. please help.
three methods use:
sql query
in sql query, truncate column so:
select left(foo,10)
calculated field
in dataset, truncate field new column using expression:
=left(fields!foo, 10)
textbox field
the same method applies above in textbox:
=left(fields!foo, 10)
Comments
Post a Comment