Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > Visual C++ MFC > Report Control
  New Posts New Posts RSS Feed - Matrix creation
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Matrix creation

 Post Reply Post Reply
Author
Message
andrewg View Drop Down
Groupie
Groupie


Joined: 24 September 2007
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote andrewg Quote  Post ReplyReply Direct Link To This Post 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
 
 
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.172 seconds.