PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Special case
  • Example
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
The DisplayOrphan property is used to:
  • Find out whether a row or a column found in a Pivot Table control is displayed when it has no parent.
  • Modify the display mode of a row or column in a Pivot Table control when it has no parent.
Remark: This property is useless if the integrity of the database corresponds to the one defined in the analysis.
Example
// PVT_Product_Sales is a pivot table
// displaying the sales of products per year.
// The products are grouped by category.
 
// Displays the products associated with a category only
PVT_Product_Sales.COL_Product.DisplayOrphan = doNever
PVTCalculateAll(PVT_Product_Sales)
Syntax

Finding out the current display mode of a row or column Hide the details

<Result> = <Row or column>.DisplayOrphan
<Result>: Integer constant
Display mode of orphan elements:
doAuto
(Default value)		The display mode is automatic according to the cardinality of the link defined in the analysis.
doNeverOnly the elements with a parent are displayed. For example, only the products associated with a category will be displayed.
doAlwaysAll the elements will be displayed, even the ones with no parent. For example, all the products will be displayed, even the ones associated with no category.
<Row or column>: Control name
Name of the row or column found in the Pivot Table control.

Modifying the display mode of a row or column Hide the details

<Row or column>.DisplayOrphan = <New display mode>
<Row or column>: Control name
Name of the row or column of the Pivot Table control to use.
<New display mode>: Integer constant
Display mode of orphan elements:
doAutoThe display mode is automatic according to the cardinality of the link defined in the analysis.
doNeverOnly the elements with a parent are displayed. For example, only the products associated with a category will be displayed.
doAlwaysAll the elements will be displayed, even the ones with no parent. For example, all the products will be displayed, even the ones associated with no category.
Remarks

Special case

To modify the display mode of orphan elements, use the DisplayOrphan property before calculating the content of the Pivot Table control (PVTCalculateAll).

Example

The Pivot Table control contains products not linked to any category:
The code used to display this Pivot Table control is:
PVT_Sales.COL_ProductName.DisplayOrphan = doAlways
PVTCalculateAll(PVT_Statistics)
The same Pivot Table control can be displayed without the products linked to no category:
The following code is used:
PVT_Sales.COL_ProductName.DisplayOrphan = doNever
PVTCalculateAll(PVT_Statistics)
See also
Minimum version required
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment