ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
  • Special case
  • Example
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
The DisplayOrphan property is used to:
  • Determine whether a row or column in a Pivot Table control is displayed when it has no parent.
  • Change 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

Getting 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 those associated with no category.
<Row or column>: Control name
Name of the row or column in the Pivot Table control.

Changing 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 those associated with no category.
Remarks

Special case

To change 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 that are not linked to a category:
The code used to display this Pivot Table control is as follows:
PVT_Sales.COL_ProductName.DisplayOrphan = doAlways
PVTCalculateAll(PVT_Statistics)
The same Pivot Table control can be displayed without the products that are not linked to a category:
In this case, the code is as follows:
PVT_Sales.COL_ProductName.DisplayOrphan = doNever
PVTCalculateAll(PVT_Statistics)
Minimum version required
  • Version 18
Comments
Click [Add] to post a comment

Last update: 05/30/2023

Send a report | Local help