Limit text in SSRS Report Table

Question

Background:

I have a table with say 40 columns reporting Employee Details. Where 39 of 40 columns are of Datatype varchar(10) and the 40th column, being Manager's comments, is of Datatype varchar(1000).

Problem:

The report is looking bad as due to one column the height of the complete row is increasing than normal expectation.

Solutions I thought of:

1. Increase width of column > Looking bad if no comments
2. SubString the data coming > Loss of data
3. Set CanGrow to False + set the Height for Row to have 2 data lines + Show text on tool tip + Export to excel link of a different report which has CanGrow as false > not very good solution

Can someone suggest a better way to handle one column with more text than the rest of them as even my 3rd approach is looking non-ideal to me?

Thanks in advance.

Answer 1

The best solution I could find was

1. Set CanGrow = False
2. Increase Width and set a generic Height
3. Show tooltip
4. Export to excel works fine and shows data unlike I expected (as the data is not truncated but just the textbox is restricted to show data in SSRS frontend)

This works for me as there is no data loss.