Hi I have created a basic report in report builder 3 i have 10 columns most of the columns conatain only about 10 characters however one column the MEMO column can be quite large, By Selecting Allow height to increase makes the report pretty much unreadable, Is there a way to get around this but also being able to keep all the data in the memo field. Like in excel you can just specifi the column with and expand the column if you need to see more of the data? Thanks John

Hi John, Generally, if we set the CanGrow property to True, the text box would have the ability to get taller the value in it is large. Do you mean this behavior makes the report unreadable? Since the column width is always static, one workaround is to set the CanGrow property to False, and then also specify the ToolTip property to the MEMO data field value. After that, the height of the textbox will not grow and MEMO text will be truncated. However, if hovering mouse above the textbox, the complete MEMO will be displayed. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi thanks for the reply all the features that you mentioned can they be done in Report Builder or do you need to set them in BIDS. I have maneged to find where you can select Allow Height To Increase But cannot see anything relating to the tooltip Memo Field Thanks John

Hi John, Yes, they can be done in Report Builder 3.0. Please refer to the steps below: Select the View tab in the main menu. Then, enable the Properties option. Select the textbox in the MEMO column. In the Properties pane, specify the CanGrow propety to False, and specify the ToolTip property to the expression like =Fields!MEMO.Value Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.