Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005

    Exclamation Unanswered: Problem with sorting in a report

    Hello everyone. I'm having a problem with a report I created. The report is a task procedure steps list. Basically, it prints all the procedure steps for a task to give to the technician. I have the report sorted by TaskID and then by ProcedureID. That sorting works fine, but the steps themselves show up in random order under each procedure heading. The order of the steps show up just fine in the underlying query, but they're all mixed up on thew report. Can anyone help me with this?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Have you tried setting the report grouping options?

  3. #3
    Join Date
    Dec 2002
    Préverenges, Switzerland
    reports totally ignore sort-order in the source query.
    right-click the report-design-view and set the sort there.

    currently using SS 2008R2

Posting Permissions

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