Exception Property

Sets or returns the exception for one or more categories.

Syntax

object.Exception

Applies To

Column Object

Columns

Layers

Row Object

Rows

Discussion

To identify exceptions used for an object, a name for each exception is required.

To remove an exception, redefine the exception style.

Type

String

Access

Read/Write (Column, Layer, Row)

Write (Columns, Layers, Rows)

Example

This example applies the "Default" exception to the third row and then prints the report.

Sub Main()
   Dim objPPRep as Object
   Dim objRepPrt as Object
   Set objPPRep = CreateObject("CognosPowerPlay.Report")
   objPPRep.Open "C:\Cubes and Reports\Exception.ppx"
   objPPRep.Rows.Item(3).Exception = "Default"
   Set objRepPrt = objPPRep.Print
   objRepPrt.PrintAllCharts = False
   objRepPrt.SetListOfRowsToPrint objPPrep.Rows
   objRepPrt.SetListOfLayersToPrint objPPRep.Layers
   objRepPrt.SetChartToPrint objPPRep.Graphs.Item(1)
   objRepPrt.IncludeLegend = False
   objRepPrt.ChartTitleOnAllPages = True
   objRepPrt.SummariesOnAllPages = True
   objRepPrt.AxisOnAllPages = True
   objRepPrt.Collate = True
   objRepPrt.PrintOut
   Set objRepPrt = Nothing
   Set objPPrep = Nothing
End Sub

Related Topics