Matrix creation

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   edit: I believe this is also called a pivot table...

We currently are developping a matrix, that is an XxY grid. We query 2 parameters from our database and return a count. 

ie: In an employee database, we want to query by SEX and HAIRCOLOR. Therefore the database would return:

M, Brown, 3
M, Blonde, 2
M, Red, 0
F, Brown 0
F, Blonde 1
F, Red, 4

Is there any functionality in the report control to turn this information into a matrix? That is, something that looks similar to:

     Brown   Blonde   Red
M      3            2          0
F       0            1          4

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
andrewg Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 24 September 2007 Status: Offline Points: 41	Post Options Post Reply Quote andrewg Report Post Thanks(0) Quote Reply Topic: Matrix creation Posted: 16 December 2008 at 8:11am
	edit: I believe this is also called a pivot table... We currently are developping a matrix, that is an XxY grid. We query 2 parameters from our database and return a count. ie: In an employee database, we want to query by SEX and HAIRCOLOR. Therefore the database would return: M, Brown, 3 M, Blonde, 2 M, Red, 0 F, Brown 0 F, Blonde 1 F, Red, 4 Is there any functionality in the report control to turn this information into a matrix? That is, something that looks similar to: Brown Blonde Red M 3 2 0 F 0 1 4