Sometimes users would like to know what the text is that is displayed under a row field at a specific depth. The way that this is done in Visual Basic 6.0 is through DynamiCube’s RowHeading property. By passing this property two parmeters (the row position and the depth of the heading you want to find), you can determine the DataItem instance that is located at the points specified. In Visual Basic 6.0 the heading’s caption is determined by default.

When using DynamiCube in a Microsoft .NET environment, the RowHeading property is changed to a get_RowHeading method. It still takes the same parameters but the developer will need to interrogate the object returned in order to determine if the specified point is a data item or if it is a GroupFooter heading.

If the point specified is a data item, the actual data item is returned. If it is a GroupFooter heading (i.e. a total row), a string is returned.

Attached are three samples (1 in C#, 1 in Visual Basic .NET and 1 in Visual Basic 6.0) that use the get_RowHeading method (or RowHeading property where applicable) in the FetchAttributes event to change the appearance of data cells based on the data cell’s value and the caption of a row field data item associated with it.

Note: The RowHeading and ColHeading properties act the same way. They simply relate to a different axis in DynamiCube.

If you have any questions about this topic, please feel free to e-mail our support team: DynamiCube.Support@DataDynamics.com.