DeleteExplorerRank Method

Deletes the rank category from an Explorer report.

Syntax

collection.DeleteExplorerRank

Applies To

Columns

Rows

Discussion

Use this method to remove the row or column that shows the rank ordinals for a category. You can remove rank categories when you update a report and no longer require this detail, or if you add nested categories to the report and must recalculate the category rank ordinals.

If an Explorer report includes a column that shows the rank ordinals for a category, use the Columns collection and this property to permanently delete the category. If an Explorer report includes a row that shows the rank ordinals for a category, use the Rows collection and this property to permanently delete the category.

This property does not delete the rank category if the report is in Reporter mode. To delete a rank category from a Reporter report, use the DeleteSelected method.

Return Type

Integer

Example

This example removes the column that shows the rank ordinals for rows in the active report.

Sub Main()
   Dim objPPRep As Object
   Dim objRslt As Object
   Set objPPRep = GetObject( , "CognosPowerPlay.Report")
   objPPRep.Columns.DeleteExplorerRank 
   Set objPPRep = Nothing
End Sub

Related Topics