title: Microsoft.Reporting.WebForms: Excel export data rows are collapsed and some data is missing
body: <p>I am using Microsoft.Reporting.WebForms to generate an Excel (old format xls, not xlsx) spreadsheet from various reports. However for some of the reports, I'm getting all the data rows coming out as collapsed/hidden:</p>
  
  <p><a href="https://i.stack.imgur.com/9qxx0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9qxx0.png" alt="enter image description here"></a></p>
  
  <p>How can I force the data rows of the report to actually appear and not collapse/hide themselves?</p>
  
  <p>edit: also, sometimes certain data rows (such as names of people in a particular role) are being omitted from the Excel export even though they export properly as PDF, HTML, or Word formats.</p>