When output SSRS report to Excel, Plus sign was moved to the far left pane in Excel. How to fix it?

Hi cat_ca,

Microsoft Excel has limitations with how it manages hidden and displayed report items when they are exported. When we export a report to Microsoft Excel format, groups, rows, and columns that contain report items that can be toggled are rendered as Excel outlines. Excel creates outlines that expand and collapse rows and columns across the entire row or column which can cause the collapse of report items that are not intended to be collapsed. This is by design. For more information about this, please see Show and Hide section in the link below:

http://ift.tt/1uMWXx3

The following similar thread is for your reference:

http://ift.tt/1lhxNgt

Thank you for your understanding.

Regards,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support