title: SSRS Export to CSV oddity
body: <p>I have a report created with a row above the header and a footer.  It is treating the row above the header as a seperate column as well as the footer and adding this row over and over for each row.</p>
  
  <p>I need one line as the first line of my CSV file (not to be repeated) and the same for the footer and all of the data inbetween those two lines.</p>
  
  <p>I have tried to take them out of the table and put them into seperate text boxes but this has the same result.</p>
  
  <p>As you can see in the CSV image it treats the HD and TR lines as rows.  The HD line should be at the top once only.  The TR line should be at the bottom once only.</p>
  
  <p><img src="https://i.stack.imgur.com/5GjUd.png" alt="This is what my layout page looks like"></p>
  
  <p><img src="https://i.stack.imgur.com/BtBIY.png" alt="This is the CSV"></p>