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