Growth Details Band

iccsi wrote:

 

I have a comments field from query result for report data source.

Because it is a navrchar(max) field, the result can be shorter or longer based on the data users entered.

I would like to have the text field and details band growth base on the data.

Are there any property to change it at run time or I need write UDF to do the task?

Make the comment field's height equal to one line's height, then set its "Stretch with Overflow" property to "True".

It is very important to set the "Position Type" property to "Floating" for every object below the comments field so that if the comments field grows then the floating objects will be moved down accordingly.

I recommend that you create a small test report to play around with the settings until you get a feel for how it all works.