Report Control - Matrix creation

Print Page | Close Window

Matrix creation

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=12941
Printed Date: 19 June 2025 at 5:42pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Matrix creation

Posted By: andrewg
Subject: Matrix creation
Date 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