|
|
|
|
|
|
|
|
|
|
DisplayEvenIfNull (Property) In french: AfficheMêmeSiNull
The DisplayEvenIfNull property is used to: - Determine whether a row or column in a Pivot Table control is displayed even if it contains no value.
- Show or hide a row or column in a Pivot Table control if it does not contain any values.
// The Month column will be displayed even if it contains no value
PVT_Sales.COL_Month.DisplayEvenIfNull = True
Syntax
Getting the current display mode of a row or column if it is empty Hide the details
<Result> = <Row or column name>.DisplayEvenIfNull
<Result>: Boolean - True if the row or column is displayed even if it is empty,
- False otherwise.
<Row or column name>: Control name Name of the row or column in the Pivot Table control.
Changing the display mode of an empty row or column Hide the details
<Row or column name>.DisplayEvenIfNull = <New display mode>
<Row or column name>: Control name Name of the row or column in the Pivot Table control to be used. <New display mode>: Boolean - True if the row or column must be displayed even if it is empty,
- False otherwise.
Remarks - Once the property is modified, the Pivot Table control is not recalculated: it is only redisplayed.
- If the property is initialized to True for a row or a column corresponding to a date, all the days (months or quarters) are displayed even if there is no matching data.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|