Range Object

An object used to specify the numerical ranges for exceptions in IBM® Cognos® PowerPlay® reports.

Discussion

You can set lowest and highest values for use with Exception objects. The values in this object determine whether a cell value has failed an exception.

You can group the Range objects in an Exception object into a Ranges collection. Use a Ranges collection to operate on the entire group of Range objects at once rather than one at a time.

Name

Description

Remove Method

Removes the Range object from the Exception object.

Name

Description

Application Property

Returns the Application object.

Index Property

Returns the position of the Range object in the Ranges collection.

LowerBoundary Property

Sets or returns the value defined for the lower boundary of the Range object.

Style Property

Sets or returns the name of the style defined for the Range object.

UpperBoundary Property

Sets or returns the value defined for the upper boundary of the Range object.

Example

This example shows how to return a Range object and returns the value defined for the lower boundary of the range in an Exception object.

Sub Main
   Dim objPPRep As Object
   Dim objPPRange As Object
   Set objPPRep = GetObject("C:\Cubes and Reports\Exception.ppr")
   objPPRep.Visible = 1
   Set objPPRange = objPPRep.Exceptions.item(1).Ranges.Item(1)
   MsgBox "Lower boundary is " &objPPRange.LowerBoundary
   Set objPPRange = Nothing
   Set objPPRep = Nothing
End Sub

Related Topics