Report Requirement - Possible?

rbuser

Hi,

I have the following scenario:

A codes table which has codes and descriptions commonly used throughout the
system. Codes are grouped together by a type nbr. So for example, all
gender items have a type of 1, all salutations have a type of 2 and so on.

I want to create a report that lists all the category 1 descriptions in one
table type down the left hand side, and all the category 2 descriptions for
along the top, like a grid. Then in each cell I want to display a count of
records present in another table for the different combinations of the two
categories, so as an example:


Hand Foot Leg Finger
(Category 1 - descriptions obtained from table)

High 1 2 0 0

Medium 0 1 2 0
<----- another table which in this example holds 10 records (count up all
the numbers)

Low 1 2 0 1

Category 2 - (descriptions obtained from same table)


Is this possible in the end-user facility? I'm hoping yes, using cross-tab
wizards, but also interested in the SQL statement I would need.

Regards

Alex

nardmoseley

What do the data tables look like? Is TypNbr and Category the same thing? I
think you are describing a table like the following? and then another table
that uses the codes? Can you describe further.

Codes Table
---------------
TypeNbr
Code
Description






--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Hi Nard,

Yes you have the drift. TypeNbr 1 would represent all the values which can
be used in Category1 field, and TypeNbr 2 would represent all the fields
that can be used in Cateory2. In essense, I want to list all the codes as
rows, and all the codes as columns regardless of them actually being used in
Category1 or Category2 (separate table).

Alex

nardmoseley

What does the second table look like - the one with the combinations of
categories that you want displayed?




--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com