Alpha Video Training
Results 1 to 2 of 2

Thread: Summary Field in a browse

  1. #1
    Member
    Real Name
    CV
    Join Date
    Oct 2000
    Posts
    114

    Default Summary Field in a browse

    Hi,it´s possible to have a Total field in a browse view,from an invoice form ?
    I mean,i got an invoice set/form:
    Date-Inv_Nr-(REGION->Cod_Prod-Price-Qty-Product)Tot_Inv

    Now i want to browse the invoice and see :
    Date-Inv_Nr-Tot_Inv

    That´s all.
    Thank you all for any help .
    Best regards.
    Claudio

  2. #2
    "Certified" Alphaholic
    Real Name
    Ken Herrold
    Join Date
    May 2000
    Posts
    1,081

    Default RE: Summary Field in a browse

    Claudio:

    To get what you want, restructure the header db with another field.

    Then use the 'Summary' option in field rules and describe the region field you want summarized.

    In this example the header is INVHEAD; the new field is TTLPARTS and the child is INVITEM.
    ==========
    INVHEAD->TTLPARTS

    [below under value you have the choice of 'user-entered', 'calculated' or 'summary' - pick summary and do this.....

    Value : Summary
    Summary of : INVITEM->PARTS
    Summary Function : Total
    Ignore Mode : None

    Post data : No
    ==============
    Above was copied and pasted and is in, of course, the field rules for the set. It'll work every time.

    Too bad it's not that easy in A5 where it's a pain in the neck.

    I have an extra A4V6 Manual - Send your mailing address and I try and send it to you. [ a little dog-eared ].

    Ken Again

Similar Threads

  1. Summary field on a form
    By NickH214 in forum Alpha Five Version 6
    Replies: 2
    Last Post: 08-06-2004, 02:42 PM
  2. invalid summary field type
    By Robert Davis in forum Alpha Five Version 5
    Replies: 0
    Last Post: 06-30-2004, 06:36 AM
  3. Summary fields with Embedded Browse
    By debwelch in forum Alpha Five Version 5
    Replies: 3
    Last Post: 09-27-2003, 06:34 AM
  4. save a summary field
    By Edward F. Schulz in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-06-2002, 04:06 PM
  5. Summary on form of browse items.
    By Rodney Efird in forum Alpha Five Version 4
    Replies: 2
    Last Post: 10-25-2000, 11:42 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
  •