How to Wrap a text in SSRS?

  • Hi Team,

    I have a report in SSRS and the layout of the report set in such a way all the column will fit into one page, saying that, the rows can flow into multiple pages, depends on the volume of the data...

    I have a column which is customer name and some times, this column has a big text and in the report, a portion of the text is not displaying...

    Is there a way I can Wrap the text so, that if the text in the customer name column is big, it expands the cell vertically...

    FYI, the " Can Grow" is set to True.

    and all the name values are trimmed.

    =iif(isnothing(Fields!LastName.Value) and not(isnothing(Fields!TypeName.Value)), trim(Fields!TypeName.Value) & " (" & Fields!Expr1.Value & ")", trim(Fields!Title.Value) & " " & trim(Fields!FirstName.Value) & " " & trim(Fields!LastName.Value)) & " (" & trim(Fields!Code2.Value) & ")"

    Regards,

    Krishna.

  • Is there a way I can Wrap the text so, that if the text in the customer name column is big, it expands the cell vertically...

    Right-click on the CustomerName textbox, and show the Properties. in Sizing Options, select "Allow Height to Increase"

  • Hi,

    That option is ticked already..but, no luck...

    Regards.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply