Sometimes you just want generated a csv. SSRS can do this but pay attention because there is a tricky thing to know about the CSV output from a SSRS report.
We create a report with just a table and an header row.
If we export this to excel, SSRS gives us a nice excel file with the configured headers and the data.
But if we generate a CSV the header row of the output is not the same as the header row of the table in the report.
This is because the CSV render engine of SSRS deletes the header row and adds the new one.
The labels in this row are the labels of the textboxes in the table cells.