Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort a report based on Expression in Group Footer? (A97 SR2)

    Can anyone tell me if it is possible to sort a report based on a calculated value in a Group footer?

    I have a report with 2 Grouping sections: FacID and CAA_ID
    The details section lists some facts about each CAA and totals one of the values in the CAA_Group Footer

    I want to sort the report by the CAA, in Descending order based on that total.

    Any ideas?

    Thanks,

    Rich P. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Sort a report based on Expression in Group Footer? (A97 SR2)

    I don't think so - at least not when you calculate the value on the form - though someone may correct me. Rather, I would suggest that you calculate the value in the report data source query, and then you can sort and group on the report.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •