Graphs
Discussion
Collections are generic objects that group or list other types of objects. You can group the Graphs objects in a Report object into a Graphs collection. Using a Graphs collection, you can operate on the entire group of Graph objects at once rather than one at a time.
Graphs present report data in a number of formats that emphasize different statistical features. For example, pie charts show the relationship of a category to the whole whereas clustered bar graphs show the trend of categories over time.
Name |
Description |
---|---|
Returns the active Graph object. |
|
Adds a Graph object to the Graphs collection. |
|
Returns one Graph object from the Graphs collection. |
|
Removes all Graph objects from the Report object. |
Name |
Description |
---|---|
Returns the Application object. |
|
Returns the number of Graph objects in the Graphs collection. |
|
Sets whether the gridlines settings are on or off for a crosstab |
|
Sets whether a user-specified label is used for the innermost summary column in a nested crosstab. |
|
Returns whether a user-specified label is used for the innermost summary row in a nested crosstab. |
|
Sets whether the rank category is hidden. |
|
Sets the current indent level for summary cells on nested crosstabs in the collection. |
|
Sets whether the summary category will remain visible on all scrolled pages. |
|
Sets whether the gridlines are on or off for category labels in a nested crosstab. |
|
Sets the current layout style for nested crosstabs in the collection. |
|
Sets the maximum number of bars on a single printed page |
|
Sets the maximum number of bars visible on a single page of scrolled data. |
|
Sets or returns whether category names appear beside pie chart slices. |
|
Sets or returns whether to show the breakdown of summary rows and columns in a crosstab. |
|
Sets whether to show the summary column for crosstabs in the collection. |
|
Sets whether to show the summary row for crosstabs in the collection. |
|
Sets whether to show label ties. |
|
Sets or returns the caption for a given statistical line on a graph. |
|
Sets or returns the color for a given statistical line on a graph. |
|
Sets or returns a statistical line on a graph. |
|
Sets or returns the line style of a given statistical line on a graph. |
|
Sets a custom value for a statistical line on a graph. |
|
Sets or returns whether scrolling is enabled. |
|
Sets or returns the user-defined label for the innermost summary column in a nested crosstab. |
|
Sets or returns the user-defined label for the innermost summary row in a nested-crosstab. |
|
Sets whether value labels fit within graph bars and pie segments. |
|
Sets the font color used for the value labels for graphs in the collection. |
|
Sets the font name used for the value labels for graphs in the collection. |
|
Sets the font size used for the value labels for graphs in the collection. |
|
Sets the position of value labels on some graph types in the collection. |
|
Sets or returns whether value labels appear next to pie chart slices. |
Example
This example opens a report, adds a new Graph object to the Graphs collection, and saves the report.
Sub Main()
Dim objPPRep as Object
Set objPPRep = CreateObject("CognosPowerPlay.Report")
objPPRep.Open "C:\Cubes and Reports\Trend.ppr"
objPPRep.Graphs.Add 5
objPPRep.Save
objPPRep.Close
Set objPPRep = Nothing
End Sub