SSRS 2005 Set SimplePageHeaders on the report instead of the server?
- by Adam
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.