Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Unanswered: Simple Group Sorting

    Hi, I want to take the information in a simple excel table and create a report that will generate the same info 3 times, each time sorting/grouping on a different column

    Here is the table

    http://img.photobucket.com/albums/v6...t123/table.jpg

    And here is the report that I'm trying to generate (first sorted by name, alphabetically, then grouped by rank, then grouped by size)

    http://img.photobucket.com/albums/v6...123/report.jpg

    I'm comfortable working with excel tables in Crystal, but I'm running into a problem repeating the information and then sorting each group separately. I also have no problem doing each group in a single report (without repeating any records), but I'd like to include all 3 groups in a single report.

    My apologies for how remedial this question is- I thought for sure that Crystal could do this easily but I've spent a couple of days on this and am running into a brick wall.

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    You can create formulas that will duplicate your data. Once you have done this you can then sort by the formulas you have created.

Posting Permissions

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