Link to home
Start Free TrialLog in
Avatar of Eoin Byrne
Eoin Byrne

asked on

SSRS Export to Excel with NO PAGE HEADER

Need to export report to Excel with no header.
Added to rsreportserver.config the following

<Extension Name="EXCEL (No Header)" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
 <OverrideNames>
    <Name Language="en-AU">Excel (No Header)</Name>
 </OverrideNames>
 <Configuration>
 <DeviceInfo>
<SimplePageHeaders>TRUE</SimplePageHeaders>
 </DeviceInfo>
 </Configuration>
</Extension>

this is what I wanted OR so I hoped..
Yes the report header is not rendered in Excel however when printing the report there is a HEADER...

I know that in EXCEL you can simply delete the page header/footer in the Page set up, But I need to export to EXCEL with no header displayed in Excel nor displayed when printed; without having to do anything in excel except press the print button.

I also tried
<Extension Name="EXCEL (No Header)" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
 <OverrideNames>
    <Name Language="en-AU">Excel (No Header)</Name>
 </OverrideNames>
 <Configuration>
 <DeviceInfo>
    <NoHeader>True</NoHeader>

 </DeviceInfo>
 </Configuration>
</Extension>

But this did nothing at all i.e. the header was displayed

I am using SSRS 2008R2
ASKER CERTIFIED SOLUTION
Avatar of Manju
Manju
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Question pending from submitter with no action / response for my comments.