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

Excel headers - using SimplePageHeaders deviceinfo setting

I want to try out placing the report header in the Excel page header instead of the worksheet. I have seen forum references to updating the config files to switch on SimplePageHeaders deviceinfo setting, but I can find no reference to this in the documentation and it appears to be ignored when I try it out. Is this in RS 2005 only? (I'm using 2000 SP2).

Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.

I am pretty sure this is new in 2005. and yes, it would help you get past your merged cell problem.

Excel headers - using SimplePageHeaders deviceinfo setting

I want to try out placing the report header in the Excel page header instead of the worksheet. I have seen forum references to updating the config files to switch on SimplePageHeaders deviceinfo setting, but I can find no reference to this in the documentation and it appears to be ignored when I try it out. Is this in RS 2005 only? (I'm using 2000 SP2).

Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.

I am pretty sure this is new in 2005. and yes, it would help you get past your merged cell problem.