Alpha Video Training
Results 1 to 6 of 6

Thread: Create a report by company with customer counts

  1. #1
    Member
    Real Name
    Jim Curtis
    Join Date
    Mar 2015
    Location
    Syracuse New York
    Posts
    29

    Default Create a report by company with customer counts

    To anyone that has already done this. I have a customer table with as many 0 to dozens of contacts at each company. I would like to generate a count by company of how many contacts each company has. And being completely new to Alpha products I need ideas quick.
    Thanks - Jim

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Create a report by company with customer counts

    Quickest to attach a sample of the table so we can demonstrate. If you have a record for each contact per company it is a simple matter to create a report with a group for company, drop any field into the group header/footer and specify count.

    Take a look at the AlphaSports sample database, Customer List report. shows customers by state.
    Open it in design mode, drag drop the customer_id field into the state group header. when the dialog asks Print what? specify count of records.
    Last edited by Stan Mathews; 03-17-2015 at 12:33 PM.
    There can be only one.

  3. #3
    Member
    Real Name
    Jim Curtis
    Join Date
    Mar 2015
    Location
    Syracuse New York
    Posts
    29

    Default Re: Create a report by company with customer counts

    Thanks!

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Create a report by company with customer counts

    If you just want the count of contacts without all the detail lines, use the Report menu, Properties, Band, Report properties, and uncheck Has Detail Section - after moving the company name field into the group header section.
    There can be only one.

  5. #5
    Member
    Real Name
    Jim Curtis
    Join Date
    Mar 2015
    Location
    Syracuse New York
    Posts
    29

    Default Re: Create a report by company with customer counts

    Thanks again Stan. Like the 2nd method for my purpose. Jim

  6. #6
    Member
    Real Name
    Jim Curtis
    Join Date
    Mar 2015
    Location
    Syracuse New York
    Posts
    29

    Default Re: Create a report by company with customer counts

    I am just checking for company's with multiple entries from a mailing list.
    Jim

Similar Threads

  1. Demographic report counts
    By Jordans17x in forum Application Server Version 10 - Web/Browser Applications
    Replies: 4
    Last Post: 02-06-2010, 12:34 PM
  2. How to create a report using Multiple company data
    By Mark-OMT in forum QReportBuilder
    Replies: 2
    Last Post: 07-02-2009, 02:47 PM
  3. Replies: 1
    Last Post: 03-05-2008, 12:21 PM
  4. Create a web page that allows user to input new order/customer info
    By jessie1_pink in forum Application Server Version 8
    Replies: 5
    Last Post: 02-05-2008, 11:53 PM
  5. Report Field Value counts
    By shawnmk in forum Alpha Four Version 6 and Prior
    Replies: 1
    Last Post: 12-11-2005, 09:55 PM

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
  •