Alpha Video Training
Results 1 to 8 of 8

Thread: Calculated Fields in reports

  1. #1
    Member
    Real Name
    Mike Vance
    Join Date
    Jun 2004
    Location
    Guernsey, Channel Islands
    Posts
    419

    Default Calculated Fields in reports

    I am trying to total a calculated field (calulated value in report layouts)

    total(calc->A30line,GRP->Cust Ref,GRP->detail)

    The wiki suggests this can be done but the calc-> A30line is not recognised by a5 - it is calculated on each grp line from fields in a dbf table correctly but I can't total the group since it is not recognised.

  2. #2
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: Calculated Fields in reports

    Hi Mike,

    Is the calc->A30line a field in the table or a value only in the report?

    What happens if you just drag the field to the section of the report you want the Total to display?
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  3. #3
    Member Bob Whitaker's Avatar
    Real Name
    Bob Whitaker
    Join Date
    Jun 2000
    Location
    Sutton-Coldfield, UK
    Posts
    695

    Default Re: Calculated Fields in reports

    Have you tried simply dragging the calculated field from the field explorer into the report / group footer and telling the wizard you want the total.

    Bob
    Bob Whitaker


  4. #4
    Member
    Real Name
    Mike Vance
    Join Date
    Jun 2004
    Location
    Guernsey, Channel Islands
    Posts
    419

    Default Re: Calculated Fields in reports

    Hi Keith & Bob

    It is a calculated field in the report layout, Keith.

    If I drag it to the area I want I can enter the total() code but the calc field (calc value is used for layouts) is not accept by a5. A5 only accepts fields from a table.

    Mike

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

    Default Re: Calculated Fields in reports

    Mike, the "area I want" has to be a footer. For the group or for the report. When you drag it there the genie will give you the option to display its value or its total.

  6. #6
    Member Bob Whitaker's Avatar
    Real Name
    Bob Whitaker
    Join Date
    Jun 2000
    Location
    Sutton-Coldfield, UK
    Posts
    695

    Default Re: Calculated Fields in reports

    Mike if you are in any doubt call me on 07889 050085

    Bob
    Bob Whitaker


  7. #7
    Member
    Real Name
    Mike Vance
    Join Date
    Jun 2004
    Location
    Guernsey, Channel Islands
    Posts
    419

    Default Re: Calculated Fields in reports

    Quote Originally Posted by Tom Cone Jr View Post
    Mike, the "area I want" has to be a footer. For the group or for the report. When you drag it there the genie will give you the option to display its value or its total.
    Hi Tom

    The area I am using is the CustRef Group footer. I have been doing exactly what you say. All seems will but after accepting the code from the genie and quitting, when I click on the Calc in the footer and check the code which I quoted earlier there is an error because a5 will not accept a calc field, only a table field, in the total() code.

    Many thanks for your comments. It may be a Win7 problem on my computer if others have no such problem.

    Mike

  8. #8
    Member
    Real Name
    Mike Vance
    Join Date
    Jun 2004
    Location
    Guernsey, Channel Islands
    Posts
    419

    Default Re: Calculated Fields in reports

    Problem solved! I wasn't using the field genie - didn't even know where to find it so was creating the calculated field independently.

    Many thanks to Bob and Tom for sorting me out.

Similar Threads

  1. calculated fields in letters and reports
    By SmartMLMer in forum Alpha Five Version 9 - Desktop Applications
    Replies: 5
    Last Post: 10-22-2009, 04:22 PM
  2. Calculated Fields in multiple reports
    By dsears36 in forum Alpha Five Version 7
    Replies: 4
    Last Post: 10-31-2007, 03:04 PM
  3. Form Calculated fields in Reports
    By Paul Main in forum Alpha Five Version 6
    Replies: 5
    Last Post: 03-07-2005, 02:50 PM
  4. Calculated Fields In Reports
    By Mike Atkinson in forum Alpha Five Version 5
    Replies: 6
    Last Post: 05-12-2004, 06:12 AM
  5. Calculated fields & Reports
    By Lloyd Frank in forum Alpha Five Version 4
    Replies: 4
    Last Post: 07-27-2000, 05:48 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
  •