Monday, March 26, 2012

Reporting Services 2005 - export to CSV with no header

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 to set 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

No comments:

Post a Comment