AutoSizeHeight (Method)

Applies To:

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

Description:

By default, Interactive Reporting Studio 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 AutoSizeHeight method to automatically size the height of a Pivot fact columns to ensure that all values display.

Syntax:

Expression.AutoSizeHeight()

Expression Required:

An expression that autosizes the height of a Pivot fact column

Example:

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

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