Alpha Video Training
Results 1 to 3 of 3

Thread: Sorting Report On Group Totals

  1. #1
    Chuck Kirkpatrick
    Guest

    Default Sorting Report On Group Totals

    How do you sort a report on group totals? I tried using the calculated group field as the sort field, but to no avail. Any help here would be appreciated.
    Chuck

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

    Default RE: Sorting Report On Group Totals

    Chuck, good question. I'm not sure the report engine can handle that. It would require multiple passes through the table, or so it seems to me. If no one can suggest an easier solution, you might investigate using an intermediate, temporary, table as the foundation for your report. Process the data yourself, write it to the temp table, run your report from there.

    -- tom

  3. #3
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,563

    Default RE: Sorting Report On Group Totals

    Chuck

    I had a similar problem with selecting on the total for a parent record. I would think that sorting has the same issue of not knowing the total soon enough.

    Tom has the right idea. My idea used an additional field in the parent that was populated by an operation and then used in the report. Whether you use the existing table or a temporary or intermediate table, this method may have problems with multiple users running the process at the same time.

    Here is a link with additional information on the selection process. You can skip the selection part and use the total field for the sorting.


    http://msgboard.alphasoftware.com/alphaphorum/read.php3?sortby=lastreply&direction=desc&num=11&id=23856&thread=23814#MSG23856

    Normalize until it hurts - Denormalize until it works.

    Best of luck! Let us know when and how it works.

Similar Threads

  1. Group Totals
    By BWilliams in forum Alpha Five Version 5
    Replies: 2
    Last Post: 10-06-2003, 06:57 AM
  2. Group Totals in Report Footer
    By Alan Lucas in forum Alpha Five Version 5
    Replies: 8
    Last Post: 05-25-2003, 04:59 PM
  3. placing group break totals in the report footer
    By eeetee in forum Alpha Five Version 5
    Replies: 4
    Last Post: 05-12-2003, 03:13 PM
  4. report footer totals for group summary
    By eeetee in forum Alpha Five Version 5
    Replies: 2
    Last Post: 03-01-2003, 12:25 PM
  5. sorting in a group in report
    By David Johnson in forum Alpha Five Version 4
    Replies: 4
    Last Post: 06-02-2000, 05:37 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
  •