CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008
drmaa
drmaa

Reputation: 3674

How to limit the length column in sql server reporting services

I have a table and some of the cells contain a lot of data. I want to truncate it after 10 characters. In the design view I right clicked the column and clicked the text box properties where I unchecked allow height increase. I checked the preview and it fixed my problem, however after I deployed the report to reporting server the length of the column is increased again. Please help.

Upvotes: 1

Views: 4075

Answers (1)

Gareth
Gareth

Reputation: 5243

Three methods you could use:

SQL Query

In your SQL query, you could truncate the column like so:

SELECT LEFT(Foo,10)

Calculated Field

In the dataset, you could truncate the field into a new column using the expression:

=LEFT(Fields!Foo, 10)

TextBox Field

The same method applies as above but just in the textbox:

=LEFT(Fields!Foo, 10)

Upvotes: 4

Related Questions