Is it possible to export to CSV and have the header contain spaces?

Question

I have a requirement for an SSRS 2005 report to be exported as a CSV, where the column headers contain spaces.

Currently the CSV header column titles are derived from the textBox property names and uses underscores instead of spaces. Is there another, better approach?

For example, currently I have:

• SSRS Report Header : Effective Date
• TextBox Name : Effective_Date
• CSV Header: Effective_Date

I would like to have:

• SSRS Report Header : Effective Date
• TextBox Name : Effective_Date
• CSV Header: Effective Date

Answer 1

Looks like its not possible, with a bit more digging I found the following Stack Overflow post:

• SSRS csv export with comma in the column header names