anna
anna

Reputation:

Text Wrapping in SSRS

How do I accomplish text wrapping of table fields in SSRS Report, and proper landscaping when rendering the report to PDF format?

Upvotes: 5

Views: 29699

Answers (3)

Tab Alleman
Tab Alleman

Reputation: 31795

Setting the CanGrow property to True will allow wrapping, and the text box will get as big as it needs to vertically to contain all the characters in its value.

To ensure the proper landscaping of PDF exports, set the PageSize of the report object accordingly (setting Width=11" x Height=8.5" will make a landscape PDF).

Upvotes: 5

Kelvin
Kelvin

Reputation: 491

Its a dumb method but if you don't have too many fields try to use the space to push the text to go to the next line.

Upvotes: 0

Aidan Ryan
Aidan Ryan

Reputation: 11607

To ensure line breaks are inserted correctly, use

=Replace(Fields!MyField.Value, vbLf, Environment.NewLine)

Set CanGrow = True.

Upvotes: 0

Related Questions