4. System Classes : RowCross Class
 
Share this page                  
RowCross Class
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):
Key_ID
Color
Aggregate
abc
blue
1
abc
green
2
abc
red
3
xyz
blue
4
xyz
red
5
xyz
yellow
6
The following table provides an example of a Row Cross arrangement based on the preceding data set:
Key_ID
Color
Aggregate
abc
blue
1
abc
green
2
abc
red
3
abc
yellow
null
xyz
blue
4
xyz
green
null
xyz
red
5
xyz
yellow
6
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.
Inherits From
Object Class (see Object Class)
DataStream Class (see DataStream Class)
SQLSelect Class (see SQLSelect Class)
QueryObject Class (see QueryObject Class)
CrossTable Class (see CrossTable Class)
Inherited By
None
Attributes
None
Methods
None