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.ReportingS ervices.Re ndering.Ex celRendere r.ExcelRen derer,Micr osoft.Repo rtingServi ces.ExcelR endering">
<OverrideNames>
<Name Language="en-AU">Excel (No Header)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<SimplePageHeaders>TRUE</S implePageH eaders>
</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.ReportingS ervices.Re ndering.Ex celRendere r.ExcelRen derer,Micr osoft.Repo rtingServi ces.ExcelR endering">
<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
Added to rsreportserver.config the following
<Extension Name="EXCEL (No Header)" Type="Microsoft.ReportingS
<OverrideNames>
<Name Language="en-AU">Excel (No Header)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<SimplePageHeaders>TRUE</S
</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.ReportingS
<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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Question pending from submitter with no action / response for my comments.