Excel Device Information Settings

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.

참고 항목

참조

Reporting Services Web Services Class Library
Render

개념

Reporting Services Device Information Settings

관련 자료

구성 파일에서 렌더링 확장 프로그램 매개 변수 설정

도움말 및 정보

SQL Server 2005 지원 받기