Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2011
    Posts
    15

    Unanswered: sorting issue on report

    hello. I have a report that I would like to sort by PROJECT NAME. The queries are sorting correctly but when I run the report it is not sorting the same way the query is. Any recomendations as to how to get ths to sort properly? Project names can be alphanumeric (ie. 2012 ADA Proj or Kroger project). The PROJECT NAME field on the table this is pulling from is set to TEXT. Thanks!

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Did you specify a sort order for the report?
    Have a nice day!

  3. #3
    Join Date
    Jun 2011
    Posts
    15
    no, just on the query. What is odd is when I look at the report the 1st page is sorted correctly but the 2nd page is not.

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Then do it. Reports have their specific sort order that does not depend on a sort order specified in a query.
    Have a nice day!

  5. #5
    Join Date
    Jun 2011
    Posts
    15
    Worked like a charm!! Thanks!

  6. #6
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

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