How to display multi-line grid headers when exporting grids to Excel

Description

With Strategy, Report Services Documents containing multi-line grid headers show only one line of the multi-line headers in Excel exports. View the image below for reference:
 

Solution

• Open the document in Design Mode.
  
• In the Layout area, select the document section to modify.
  
• From the Format menu, select Properties and Formatting.
  
  The Properties and Formatting dialog box opens.
  
• From the left, click Layout. 
  
• Select the Automatically fit rows check box. 
  
  

1. Click OK to apply changes and return to the document.

The Excel export now shows all lines for multi-line headers as shown below.

Still having problems? Feel free to start a discussion on Community!
Or reach out to your support liaison to create a case for our Support team.