Alpha Video Training
Results 1 to 4 of 4

Thread: Using Calc fields in report detail?

  1. #1
    Themis Skiathitis
    Guest

    Default Using Calc fields in report detail?

    I have been using a calc field to sort the detail section of a report. Although it doesn't appear in the field list by typing in Calc-Rating1 I am able to have the records sorted by the calc field.

    Problem is that I now want to sort by a multi-field expression and both of the fields are calculated.

    I have tried putting in Calc->Rating1+Calc->Winpc but keep getting an error. Is there any way this can be done?

    These go into the Order Expression area on the details design dialogue box.

    As usual, any help, ideas or info would be appreciated.

  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: Using Calc fields in report detail?

    In the order expressions dialog, click on the triangular "smart" button to the right of the expression area, you now see the table fields in the order builder window. Click on the expression button under the help button. Here you can access your calculated fields.

  3. #3
    Themis Skiathitis
    Guest

    Default RE: Using Calc fields in report detail?

    When I go into the Order Expression area I get an Order Builder screen that doesn't have that triangle button.

    Just the various fields from the db's in the set across the top.

    I dont seem to have any difficulty getting to the calc fields if i go into the Filter Expression, but on the order expression they aren't there.

    Am i looking in the right spot?

  4. #4
    Themis Skiathitis
    Guest

    Default RE: Using Calc fields in report detail?

    Ok got it! Thanks Stan!

Similar Threads

  1. Calc field based on calc fields
    By Stan Mathews in forum Alpha Five Version 5
    Replies: 0
    Last Post: 07-10-2003, 09:48 AM
  2. Filtering a Report on Calc Fields
    By Doug Briggs in forum Alpha Five Version 5
    Replies: 8
    Last Post: 07-07-2003, 08:28 AM
  3. Intelligent Calc Fields on Report
    By Roy Irby in forum Alpha Five Version 5
    Replies: 8
    Last Post: 04-23-2003, 05:28 PM
  4. Speed of global calc fields vs layout calc fields
    By russ Boehle in forum Alpha Five Version 4
    Replies: 0
    Last Post: 05-27-2001, 12:29 PM
  5. Calc Fields on Form vs Report
    By forskare in forum Alpha Five Version 4
    Replies: 20
    Last Post: 03-12-2001, 04:49 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
  •