1 out of 2 rated this helpful - Rate this topic

Excel Device Information Settings

SQL Server 2005

The following table lists the device information settings for rendering in Microsoft Excel format.

Setting	Value
OmitDocumentMap	Indicates whether to omit the document map for reports that support it. The default value is false.
OmitFormulas	Indicates whether to omit formulas from the rendered report. The default value is false.
RemoveSpace	Indicates whether to omit rows or columns that do not contain data and are smaller than the given size. Use this setting to remove extra rows or columns that do not contain report items. You must include an integer or decimal value followed by "in" (for example, 0.5in). The default value is 0.125in.
SimplePageHeaders	Indicates whether the page header of the report is rendered to the Excel page header. A value of false indicates that the page header is rendered to the first row of the worksheet. The default value is false.

Reference

Reporting Services Web Services Class Library
Render

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ

Hyperlinks

I've seen several posts scatterd through the internet and can't find a good resolution to disable the hyperlink output when choosing excel as an export option. It seems like the device information settings would be a logical place to allow for configuration of this - something like "OmitHyperlinks", however I don't see that it's ever been corrected in SSRS 2005 or now again in SSRS 2008. I saw several posts from Microsoft representatives that stated this is an often requested feature and that it would be available in later releases. It doesn't seem that difficult to implement and I'm wondering why it wasn't resolved. I'd like to avoid creating a custom render for this purpose. Perhaps I'm missing something.

History

1/23/2009
Variable1

Excel Device Information Settings

Reference

Concepts

Other Resources

Help and Information