Alpha Video Training
Results 1 to 5 of 5

Thread: Summary Report

  1. #1
    Member
    Real Name
    Kelley Martin
    Join Date
    Nov 2006
    Posts
    32

    Default Summary Report

    Can someone guide me.

    I would like to create a summary report of each item sold and the quantity for the month.

    From my "Invoice.set" I would like to use "invitem.dbf", "partnumber" and "qty". Have the "partnumber" listed once with the total qty sold for the month.

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default Re: Summary Report

    If I were doing this I'd create a new set. Items would be primary, linked one to one back to the invoice_hdr table. My report layout would have a group break and be sorted on the partnumber field. It would not have a details band. Instead I'd put the partnumber and a calc field in the group footer. The calc field would be created by dragging the qty field into the footer and telling alpha to total it over the records in the group. The range of records included in the report would be set with a filter on the date field in the invoice_hdr table.

  3. #3
    Member
    Real Name
    Kelley Martin
    Join Date
    Nov 2006
    Posts
    32

    Default Re: Summary Report

    Tom, Thanks for the help. Everything seems to work correctly expect for when the report is ran next to the first "part number" there seems to be a total of all the item which throws off the count for each item. Any idea?

    Just a run down of what I did.

    Created a new set. Created report, added a group for the "part number", placed the "partnumber" field under the group footer and created a calculatef field for the qty - "tot_invitem_Qy_for_part = total(invitem->Qy,grp->part,grp->detail)"

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default Re: Summary Report

    I would have expected

    total(invitem->Qy,grp->part)

    Have you tried that?

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

    Default Re: Summary Report

    Can you take a screenshot of your desgin like my attachment and attach it here?
    There can be only one.

Similar Threads

  1. Summary Report
    By Nick Marodis in forum Application Server Version 10 - Web/Browser Applications
    Replies: 8
    Last Post: 12-21-2009, 03:25 PM
  2. Doing just Summary Report
    By bluize in forum Alpha Five Version 9 - Desktop Applications
    Replies: 2
    Last Post: 11-20-2009, 05:47 PM
  3. Summary Report
    By Connie Brouillette in forum Alpha Five Version 5
    Replies: 1
    Last Post: 09-02-2004, 05:35 PM
  4. summary report
    By John Lemisch in forum Alpha Five Version 4
    Replies: 5
    Last Post: 12-01-2001, 02:58 AM
  5. set report summary report non zero balances
    By vasant panjabi in forum Alpha Five Version 4
    Replies: 2
    Last Post: 11-15-2001, 05:45 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
  •