Data Cut off when exporting to excel in SQL Reporting Services 2005.

Question

I am having huge lines data which could accomdate in Textbox.

While I am exporting to excel the wrapping up of data occurs and the data is being cut off.

When i manually change the textbox height i can see the full data but i need the full data to be displayed in the first time itself.

Answer 1

Please someone suggest me some answer

Answer 2

In your report layout, set the CanGrow property of the Textbox to True.