Matrix creation |
Post Reply |
Author | |
andrewg
Groupie Joined: 24 September 2007 Status: Offline Points: 41 |
Post Options
Thanks(0)
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
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |