|
|
|
|
|
DisplayOrphan (Property) In french: AfficheOrphelin
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.
// 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. | 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 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: | | doAuto | 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 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)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|