I have a very simple table report. I need to be able to export it as a CSV, but I can not have the first line being the header. I need just the data and no header. Is there a way to do this? I tried working with the Output tab on the tables properties, but I only seem to be able to include or exclude columns not the column headers. I look forward to you response. FredZilz

Hello, To do this you need toset the DeviceInfo parameter "NoHeader" to True: http://msdn2.microsoft.com/en-us/library/ms155365.aspx -Chris

Excellent, I can now get my results using URL Access. Can, I set Device information settings as the default for a particular report (not at the server level but at the report)? Thanks

Hello, DeviceInfo parameters can be set 1) via URL access, 2) when rendering with the SOAP API, or 3) set in the report server config file for the entire server (all reports). However, they cannot be set as default for particular reports. -Chris

hi.. i am trying with config file change.. still doesnn't work.. and gettin nowhere in searching in the internet.. can you help me, how made this work to csv without headerVontlin

Hi Chris,I need to personalize the csv export type but only for one report. Is there a way to achieve this and not having the same configuration for the whole server?Thanks,Carlos

Hi Chris, I need to personalize the csv export type but only for one report. Is there a way to achieve this and not having the same configuration for the whole server? Thanks, Carlos http://blogs.infosupport.com/blogs/marks/archive/2010/04/18/modify-reporting-services-export-to-csv-behavior.aspx M. Streutker, Info Support | Blog

Is there a way of having one report export to a CSV as part of a SQL Server reporting subscription without the header?