PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..DisplayEvenIfNull is used to:
  • Find out whether a row or a column found in a Pivot Table control is displayed even if it contains no value.
  • Configure a row or a column found in a Pivot Table control so that it is displayed (or not) even if it contains no value.
Example
// The Month column will be displayed even if it contains no value
PVT_Sales.COL_Month..DisplayEvenIfNull = True
Syntax

Finding out 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>: Character string (with or without quotes)
Name of the row or column found in the Pivot Table control.

Modifying the display mode of an empty row or column Hide the details

<Row or Column Name>..DisplayEvenIfNull = <New Display Mode>
<Row or Column Name>: Character string (with or without quotes)
Name of the row or column in the pivot table to use.
<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 re-displayed.
  • If the property is initialized to True for a row or a column corresponding to a date, all the days, months, quarters, ... are displayed even if there is no corresponding data.
See also
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment