I have created a header on a report and i want it to output to csv. what is the setting for this, when i render to csv there is no sign of header. Also The first column contains integer field with up to 20 digits how can i make sure that csv interprets this data type correctly. Thanks paul

To influence what is and what is not exported you can change the DataElementOutput property. Default value is Auto, Output and NoOutput speak for themselves. What does the export do with the 20 digits field that you don't want?

the dataelement for this is set to "output" and it contains "11393200117952" it is contained correctly on the CSV file. When a user open this in excel it goes to scientific notation. Is this just a feature that the user should handle? Any help on the Header?

The DataElementOutput setting was meant for the header issue. Does changing the property to Output not make SSRS export the header? You need to change it for every header column separately. Or just select the all the cells in that row and change it with 1 action. Does excel not change the way it shows the digit to scientific when the cell is to narrow for the entire number? I'm pretty sure it's something excel does and not affected by the export from SSRS. Excel does it for me when i paste the number in it as well. Just change the field property to number instead of general and it will display the number correctly.

I think we are on cross wires for me the header is a line of detail that appear before the real content of the file.. eg following is the file contents.. Header00011000.csv 1233434,myname, myaddress 1223234,yourname, youraddress footer00011000

Does the table you want to export look like this? Header row: ID - Name - Adress Detail row 1: 1233434 - myname - myaddress Detail row 2: 1223234 - yourname - youraddress The header in SSRS is nothing more than another row with column-titles in it. As such you can change the setting just like any other cell to make it output or not.

Hi Paul, Which version of Reporting Services you are using, and the header you mentioned is group header, table header, report page header or something else? If possible, please post a picture to show the report structure in Design mode. Based on my testing, only the table header can be exported to CSV with data in the table. It might be by design since the CSV is a simple comma delimited text file for a data table. For the second issue, please open the CSV in Notepad to check if values are stored as integer. If so, the scientific notation format might be the default behavior of Excel. Users need to change the format cells properties of the column. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.