Exporting from SSRS to Excel with no headers

Question

Is there a way to export to excel from an SSRS report so that the header that displays on the first page of the report is omitted only in the excel export? Currently, it adds a frozen frame to the top of the worksheet.

Answer 1

Unfortunately Reporting Services 2000, 2005, and 2008 do not have a way to alter the results of the report based on the render-method selected by the user. This means your only alternative is to provide a parameter to the report that will hide or show the header.

If users are accessing reports via Report Manager, then this is generally not a reasonable resolution and there's no good resolution to the problem. If you are running subscriptions that render the report to Excel and delivering the reports either via email, file share, or SharePoint, then this method is adequate for resolving the problem.

I would be willing to pay a small amount of money for a custom render-method extension if someone has coded a solution to this. But to-date, I haven't seen a set of code that achieves this purpose.

Answer 2

Update

Also see my answer about how to add a new Excel rendering option that strips the header

Original answer follows:

If you can get the URL for the Excel output (some versions of SSRS leave the browser displaying it), you can append some code to the end:

&rc:SimplePageHeaders=True

This removes the header. This is a manual hack that comes in handy, or you can add it to the rsreportserver.config file

<Render>
    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
        <Configuration>
            <DeviceInfo>
                <SimplePageHeaders>True</SimplePageHeaders>
            </DeviceInfo>
        </Configuration>
    </Extension>
</Render>

Failing that there's Aspose.Cells or OfficeWriter - I haven't used either product, I just know of their existence.

Or for the really brave, you can create your own custom renderer