|
|
|
|
|
DisplayEvenIfNull (Property) In french: AfficheMêmeSiNull
The property AfficheMêmeSiNull property property allows you 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.
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 is to be displayed even if empty,
- False otherwise.
Remarks - After modifying the property, the Pivot Table control is not recalculated: it is simply 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|