AutoSizeWidth (Method)

Applies To:

PivotLabel collection, PivotFact object, OLAPLabel object, OLAPMeasure object, QueryLabel object

Description:

By default Interactive Reporting truncates Pivot fact columns evenly, regardless of the length or height of data values. Numeric data that does not fit, is replaced with pound signs (#). Use the AutoSizeWidth method to automatically size the width of a Pivot fact column to ensure that all values are displayed.

Syntax:

Expression.AutoSizeWidth()

Expression Required:

An expression that autosizes the width of a Pivot fact column

Example:

This example shows how to auto size the height and width of the Unit Sales fact column:

ActiveDocument.Sections["Pivot"].Facts["Unit Sales"].AutoSizeWidth()
ActiveDocument.Sections["Pivot"].Facts["Unit Sales"].AutoSizeHeight()