Excel OmitFormulas DeviceInfo parameter:

Is there a way I can set OmitFormulas DeviceInfo parameter to true for a whole site so that when a user exports the data to Excel, they only get the values?

Joe

Yes, this is possible in RS 2005 by modifying the RSReportServer.config file.

You could either modify the original "Excel" entry or add a new one.

<Render>
<Extension Name="Modified Excel" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
<OverrideNames>
<Name Language="en-US">Modified Excel</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OmitFormulas>true</OmitFormulas>
</DeviceInfo>
</Configuration>
</Extension>
...
</Render>
Additional Excel deviceinfo settings:
http://msdn2.microsoft.com/en-us/library/ms155069.aspx

-- Robert