Kayza
Ok, so I think what you're saying is you want these TWO crosstabs in ONE
report, one crosstabbing by gender, the other by Impairment. Which means
both must come off the same dataset.
A standard view won't work, yuou're right: combining the two tables to
include Gender with Impairment, you'll get these rows:
Child Table
CleintID Impairment Gender
Code
1 V M
2 V F
2 H F
3 W F
2 W F
4 H F
3 V F
4 C F
1 C F
So a crosstab of Client by Gender would give false answers
M F
1 7
instead of the correct
M F
1 3
I think that a sub-report IS your best bet - wait for 7.5. Until then, the
other choice is to
1. Base report on the view above
2. use crosstab to get your second crosstab by impairment
3. Create a view of totals by gender:
CReATE VIEW GenderTots (Gender, NumClient) as SELECT Gender, COUNT(*) FROM
MasterTable GROUP BY Gender
4. In the report, the gender crossta data is done by lookups to this table,
one for M and one for F!
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 10:34 AM
Subject: [RBG7-L] - Re: Another Crosstab question
> 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”
>
>
