SSRS 2005 Set SimplePageHeaders on the report instead of the server?
Posted
by Adam
on Stack Overflow
See other posts from Stack Overflow
or by Adam
Published on 2010-06-15T19:29:26Z
Indexed on
2010/06/15
19:32 UTC
Read the original article
Hit count: 904
I have one report that does not export to excel friendly from SSRS 2005. I know I can use
<Render>
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
<Configuration>
<DeviceInfo>
<SimplePageHeaders>True</SimplePageHeaders>
</DeviceInfo>
</Configuration>
</Extension>
</Render>
in the rsreportserver.config, but I am not the only person with reports on this machine. I also found that you can pass
&rc:SimplePageHeaders=True
in the url to export the report programatically.
I tried adding the &rc:SimplePageHeaders=True
to the end of the url when navigating to the report manager, but when I select excel from the dropdown and click export the headers are still exported. I even tried setting the rc:Command=Render
and rc:Format=EXCEL
in the url too without any luck.
Is there a way to do what I am trying to do?
note: I am wanting to render the report on the built in report manager and use the build in export to excel dropdown, not in an app or website.
© Stack Overflow or respective owner