ShowSummaryBreakdown Property (Explorer)

Sets or returns whether to show the breakdown of summary rows and columns in a crosstab.

Syntax

object.ShowSummaryBreakdown

Applies To

Discussion

Use this property to show subtotals for each outer level summary. When this property is set to True, the report inserts automatic subtotals derived from details in the crosstab rows and columns. In a crosstab with a long list of data, you can use the summary data to outline the information in the report. Set this property to true for nested crosstabs so that the nested level summary is visible.

The ShowSummaryRow or the ShowSummaryColumn and the ShowSummaryBreakdown properties must both be set to True to see the details for each outer level summary row or column. If the ShowSummaryRow or ShowSummaryColumn property is set to True, but the ShowSummaryBreakdown is set to False, only a single row or column appears for each summary. If the ShowSummaryRow or ShowSummaryColumn property is set to False, but the ShowSummaryBreakdown is set to True, no summary rows or columns appear.

Default: True

Type

Boolean

Access

Read/Write (Graph)

Write (Graphs)

Example

This example sets the ShowSummaryBreakdown property to false so that the crosstab hides the subtotal summary for the nested categories.

Sub Main()

   Dim objCubeCategories As Object

   Dim objPPRep As Object

   Dim objGraph As Object

   Const level_0 = 0

   Const level_1 = 1

   Const add_to_current = 0

   Const add_to_all = 1

   Const as_parent = 0

   Const as_child = 1

   Set objPPRep = CreateObject("CognosPowerPlay.Report")

   objPPRep.New "D:\Cubes and Reports\Great Outdoors.mdc",
-1

   objPPRep.ExplorerMode = True

   objPPRep.Visible = True

   Set objCubeCategories = objPPRep.CategoryList()

   objCubeCategories.Add level_1, "Locations"

   objPPRep.Rows.AddLevel objCubeCategories, level_0,
_

         add_to_all, as_child

   Set objGraph = objPPRep.Graphs.Item(1)

   objGraph.SetType 0

   objPPRep.Graphs.ShowSummaryRow = True

   objPPRep.Graphs(1).ShowSummaryBreakdown = False

   Set objCubeCategories = Nothing

   Set objPPRep = Nothing

End Sub