DisplayOrphan (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls

Special case
Example

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

DisplayOrphan (Property)

In french: AfficheOrphelin

The property AfficheOrphelin property allows you 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.

Note: If the integrity of the database matches that defined in the analysis, this property is not required.

Example

// TCD_Vente_Produit est un tableau croisé dynamique 
// affichant les ventes de produits par an. 
// Les produits sont regroupés par catégorie. 

// Affiche uniquement les produits associés à une catégorie
TCD_Vente_Produit.COL_Produit.AfficheOrphelin = doNever 
PVTCalculateAll(TCD_Vente_Produit)

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.
doNever Only the elements with a parent are displayed. For example, only the products associated with a category will be displayed.
doAlways All the elements will be displayed, even the ones with no parent. For example, all 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:
doAuto
(Default value) The display mode is automatic according to the cardinality of the link defined in the analysis.
doNever Only the elements with a parent are displayed. For example, only the products associated with a category will be displayed.
doAlways All the elements will be displayed, even the ones with no parent. For example, all 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:

TCD_Vente.COL_NomProduit.AfficheOrphelin = doAlways
PVTCalculateAll(TCD_Statistiques)

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:

TCD_Vente.COL_NomProduit.AfficheOrphelin = doNever
PVTCalculateAll(TCD_Statistiques)