PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

X
Y
  • 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
..DisplayOrphan 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.
Note: 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 Name>..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 Name>: Character string (with or without quotes)
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 Name>..DisplayOrphan = <New Display Mode>
<Row or Column Name>: Character string (with or without quotes)
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, ..DisplayOrphan must be used before le 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)
Minimum required version
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment