SSRS csv export

Question

Hi Team,

I am working on SSRS 2005. I have a column that has a comma to be displayed. I write it in the header; but the SP returns without comma for the column header. When I export the report to csv, the column names are taking the name of the text box wich is not having comma. Is there a way to display comma in the header when exported to csv?

Thanks

Lijo

Answer 1

.........&rs:format=CSV&rc:FieldDelimiter=%23 for # delimiter and &rs:format=CSV&rc:FieldDelimiter=";"

Not sure you can do it directly from Report Manager without altering config files somewhere

---

edit:

Just rereading this, are you returning the column headers from the proc like this

Select   
       tbl.colname [my column name, some text],  
       tbl.col2    [another, col]

? The square brackets will allow you to escape characters

Answer 2

Hi,

Let me rephrase the question.

By default, csv takes the text box name as the csv header name for the columns. The text box does not allow a space. How do I make a different header than the text box for the csv.

Note: The solution has to be only for one report; not global.

Thanks

Lijo