locked
Disabling wrap text button in excel using SSRS RRS feed

  • Question

  • Whenever a SSRS report is exported to excel, the WRAP TEXT button gets enabled. How to disable that  WRAP TEXT button using SSRS?
    • Moved by Hemendra Agrawal Thursday, January 9, 2014 5:45 AM off topic. Not SharePoint question
    Thursday, January 9, 2014 5:02 AM

Answers

  • Hi Sonia.Sharma,

    Based on my test, In SQL Server Reporting Services (SSRS), it is not support to disable WRAP TEXT button when export to Excel.

    In order to disable text box content wrap when export to Excel, we can adjust the text box with enough width sixe. When we export to Excel, although the WRAP TEXT button is checked, the layout of the report will not mess.

    Alternatively, we can uncheck the WRAP TEXT button when we export report to Excel. Please refer to the following steps:
    1. Select the entire report in the Excel.
    2. Uncheck the WRAP TEXT button.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Marked as answer by Alisa Tang Tuesday, January 14, 2014 6:54 AM
    Friday, January 10, 2014 2:31 AM