Alpha Video Training
Results 1 to 5 of 5

Thread: Demographic report counts

  1. #1
    Member
    Real Name
    Jordan Shilts
    Join Date
    Jun 2003
    Posts
    42

    Default Demographic report counts

    I have a table of clients with demographic information (sex, race, ethnicity, marital status, age, primary language), and now I need to create a report that totals the number of clients for each of the values in each of those fields.
    so lets say i want to look at marital status, sex, and primary Language.

    Marital status options are
    Single
    Married
    Divorced

    And language options are based off a table that can be updated.

    what i want to do is create a report that has the total of all the different demographic fields involved, so i want it to look like this

    Marital Status Totals
    Single 213
    Married 466
    Divorced 2431

    Primary Language totals
    English 3462
    Spanish 2311

    Gender Totals
    Male 5422
    Female 5454

    I tried using groups and sub-reports with groups and it always combines the groups into embedded sub-groups so i get something like this. (I also tried using cross-tab and summary operations and they end up the same way)

    Single 50
    Male 25
    Female 25
    Divorced 75
    Male 50
    Female 25
    Married 100
    Male 54
    Female 46

    I could manually create a calculated field for each viable field value for each of the 6 fields, but that would be... a nightmare. Is there any way to do what i'm describing? Thanks!

  2. #2
    Member StephenP's Avatar
    Real Name
    Stephen Pilon
    Join Date
    Apr 2000
    Location
    Front Royal, Virginia
    Posts
    491

    Default Re: Demographic report counts

    I would use something like this. It has a calculated field for each "watch" type, and just adds 1 when true, and 0 when not, thus giving you the totals. Depending on how the rest of your report is set up, you may need to modify the groupings (e.g., GRP->GRAND,GRP->DETAIL).

    Marital Status Totals
    Single 213 -- total(iif(martial_status="Single",1,0),grp->detail)
    Married 466 -- total(iif(martial_status="Married",1,0),grp->detail)
    Divorced 2431 -- total(iif(martial_status="Divorced",1,0),grp->detail)

    Primary Language totals
    English 3462 -- total(iif(prim_lang="English",1,0),grp->detail)
    Spanish 2311 -- total(iif(prim_lang="Spanish",1,0),grp->detail)

    Gender Totals
    Male 5422 -- total(iif(gender="Male",1,0),grp->detail)
    Female 5454 -- total(iif(gender="Female",1,0),grp->detail)
    Stephen Pilon
    Associate Librarian
    Christendom College

  3. #3
    Member
    Real Name
    Jordan Shilts
    Join Date
    Jun 2003
    Posts
    42

    Default Re: Demographic report counts

    Thanks for your reply stephen! that kind of structure would work if the groupings were static (like on an aging report), but i want the users to be able to add/remove languages, for example, without having to add new calculated fields. I'm not sure if this is possible with alpha tools, I may have to do some pre-processing for the report.

  4. #4
    Member Chris.Tanti's Avatar
    Real Name
    Chris Tanti
    Join Date
    May 2000
    Location
    Cardiff, South Wales, UK
    Posts
    368

    Default Re: Demographic report counts

    Sounds like you need a crosstab.
    I have never enjoyed using this in A5, and tend to switch to excel's equiv, pivot table.

  5. #5
    Member
    Real Name
    Jordan Shilts
    Join Date
    Jun 2003
    Posts
    42

    Default Re: Demographic report counts

    Chris,
    I did try using a cross tab operation, but found that it works the same way groups do in reports; they embed groups within each other. I may be wrong but I don't think cross-tabs will work either. Thanks for the suggestion though!

Similar Threads

  1. counts and summaries
    By dik_coleman in forum Alpha Five Version 8
    Replies: 10
    Last Post: 01-14-2008, 09:55 AM
  2. Report Field Value counts
    By shawnmk in forum Alpha Four Version 6 and Prior
    Replies: 1
    Last Post: 12-11-2005, 09:55 PM
  3. Percent of Counts in Reports
    By Chris.Tanti in forum Alpha Five Version 4
    Replies: 14
    Last Post: 06-15-2000, 12:23 PM
  4. Conditional Counts
    By Jim VanGelder in forum Alpha Five Version 4
    Replies: 2
    Last Post: 05-17-2000, 05:34 AM
  5. Printing group counts in order
    By Pete Cantele in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-13-2000, 10:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •