rlecjr
March 26th, 2001, 06:02 PM
Hello -
I am populating data into an MSFlexGrid. I am able to load the data straight into the table, but that is not what I want. The data has to be in the form of a Crosstab (I think that is what it is called) where the headers across the top and the first field along the left side have intersecting points.
Take the following data for example: Classes, Students, Grades. Classes would be across the top row, Students would be across the side column and the intersecting points are the grades. This data comes in as all single records, such as:
Input:
Math John 78
Math Jim 82
Math Jane 47
English Mike 98
English John 42
English Rose 87
Output: (Lines are here for formatting purposes)
---- - Math - English
John - 78 --- 42
Jim -- 82
Jane - 47
Mike - ----- - 98
Rose - ----- - 87
I am populating data into an MSFlexGrid. I am able to load the data straight into the table, but that is not what I want. The data has to be in the form of a Crosstab (I think that is what it is called) where the headers across the top and the first field along the left side have intersecting points.
Take the following data for example: Classes, Students, Grades. Classes would be across the top row, Students would be across the side column and the intersecting points are the grades. This data comes in as all single records, such as:
Input:
Math John 78
Math Jim 82
Math Jane 47
English Mike 98
English John 42
English Rose 87
Output: (Lines are here for formatting purposes)
---- - Math - English
John - 78 --- 42
Jim -- 82
Jane - 47
Mike - ----- - 98
Rose - ----- - 87