Erik
Erik

Reputation: 161

SSRS 2005 export to csv - I don't want the header?

Currently my SSRS 2005 server is exporting the names of the textboxes as the header when a report is exported to CSV. I've tried changing the device information settings in the rsreportserver.config file:

<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
            <configuration>
                <DeviceInfo>
                    <NoHeader>true</NoHeader>
                </DeviceInfo>
            </configuration>
        </Extension>

After re-starting Reporting Services, I'm still getting the header. Is the change I made correct?

Upvotes: 2

Views: 1931

Answers (1)

Erik
Erik

Reputation: 161

I finally figured out why changes to the rsreportserver.config didn't take.

  1. I didn't capitalize "Configuration" and "/Configuration".
  2. Re-starting reporting services doesn't reload this configuration file; re-starting IIS reloads this configuration file.

Upvotes: 2

Related Questions