The RowCross class repeats a row for every represented value for each row identifier in a set of data. Each constructed row contains a column for the row identifier, a column containing a value from the CrossColumn attribute of the CrossTable class, and an aggregate value.

The RowCross class returns one value at a time for each row identifier, facilitating manipulation of individual values prior to display. It is commonly used to supply data for crosstab displays because it allows the display to respond in a dynamic fashion to the data being supplied to it. You can perform intermediate calculations on the data as it is being received because each cell is delivered in a separate row of a continual stream of data.

The following table provides an example of a data set that contains a row identifier (the Key_ID column), values that populate the CrossTable's CrossColumn attribute (the Color column), and aggregate values that represent the data to be returned (the Aggregate column):

The following table provides an example of a Row Cross arrangement based on the preceding data set:

The values represented by the CrossColumn attribute (blue, green, red, and yellow) are repeated for each unique identifier (abc and xyz), whether the row identifier contains an aggregate value for each color in the base data set. Null is displayed for aggregate values in rows corresponding to nonexistent rows in the base data set.

A fixed number of rows, based on the value of the CrossColumn attribute of the CrossTable class, is created for each row identifier.