This is obviously a sever subet of the data, but should give you an idea
of what I am trying to do:
Master Table
Client FullName Gender HousingType Ethnicity Address Telephone# ZipCode
1 Test Person M Rent B 1234 Test Drive 718 777-8888 11224
2 Another Person F Own W 456 Test Road 718 555-1414 11224
3 Test Client F Own A 125 Test St 718 555-7878 11225
4 Random Name F Lease W 555 Test Road 212 963-4587 11224
Child Table
CleintID Impairment
Code
1 V
2 V
2 H
3 W
2 W
4 H
3 V
4 C
1 C
Sample Report
M F
Count ClientID 2 2
V H W C
Count Clientid 2 2 3 2
David M. Blocker wrote:
Kayza
I'm sure this can be done with views combined, but I can't picture the
layout of the report you want. Can you send a few sample rows from Master
table, a few from Child and the layout of the report you want?
David Blocker
[EMAIL PROTECTED]
781-784-1919
Fax: 781-784-1860
Cell: 339-206-0261
----- Original Message -----
From: "Kayza Kleinman" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, October 20, 2004 1:23 AM
Subject: [RBG7-L] - Another Crosstab question
As you can see, I'm happily exploring the capabilities of the crosstab
feature of the report generator. So, I have another question:
Say I have a table with clientID, category1, category2, category3. Now
each row is unique, but the combination of clientid and category1 may
not be. If I just want the count of clientid for each possible value of
category 1, that works. The question is, can I get a count of the number
of UNIQUE client ids for each possible value of category1.
What I actually need to accomplish is this:
I have a master table with clientid (unique), category1, category3.
There is a child table with clientid, category2. Neither column is
unique, but the combination is. I need one report that gives me a count
of the unique number ids of each possible value of category1, the same
for category3 and a count of the number of ids for category2. I can get
each one separately using the crosstab feature quite nicely. But, if I
want it altogether, I see no other way than a view, which will give me
multiple occurrences of clientid+category1 or clientid+category3
combinations. Perhaps I should try subreports?
--
Kayza Kleinman
Director, Nonprofit Helpdesk
Jewish Community Council of Greater Coney Island, Inc.
3001 West 37th Street
Brooklyn, NY 11224
Tel. 718 449-5000
Fax 718 946-8240
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
www.nphd.org <http://www.nonprofithelpdesk.org/>
“Putting Technology to Work For You”
--
Kayza Kleinman
Director, Nonprofit Helpdesk
Jewish Community Council of Greater Coney Island, Inc.
3001 West 37th Street
Brooklyn, NY 11224
Tel. 718 449-5000
Fax 718 946-8240
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
www.nphd.org <http://www.nonprofithelpdesk.org/>
“Putting Technology to Work For You”
