New call-to-action
Results 1 to 4 of 4

Thread: Count records in report

  1. #1
    Member
    Real Name
    David Corcoran
    Join Date
    Oct 2001
    Posts
    218

    Default Count records in report

    I have a report which is a list of shares grouped by account number. I want the report footer to show the total number of shares, I know it is simple but I cannot get it to work could anyone tell me what the expression should be.

    Kind regards
    David

  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: Count records in report

    total(your_tablename-"shares_qty_fieldname,grp-"grand)

  3. #3
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,662

    Default RE: Count records in report

    David

    You can also use the drag and drop genie to drop a field on the proper region and let Alpha make the expression for you.

    See attach image of the genie.

  4. #4
    Member
    Real Name
    David Corcoran
    Join Date
    Oct 2001
    Posts
    218

    Default RE: Count records in report

    Thank you.

    Kind regards
    David

Similar Threads

  1. Count of records on a report
    By Gren Brown in forum Alpha Five Version 4
    Replies: 4
    Last Post: 07-10-2002, 11:25 AM
  2. Count of records in a report
    By BeckyRicci in forum Alpha Five Version 4
    Replies: 4
    Last Post: 08-16-2001, 02:14 PM
  3. count records
    By crimmelcp in forum Alpha Five Version 4
    Replies: 7
    Last Post: 04-18-2001, 02:11 AM
  4. produce a count of records in a report
    By abe kravetz in forum Alpha Four Version 6 and Prior
    Replies: 2
    Last Post: 07-19-2000, 11:46 AM
  5. Count of records.
    By Rodney Efird in forum Alpha Five Version 4
    Replies: 1
    Last Post: 05-17-2000, 06:34 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
  •