Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,869
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort Not Working? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Here

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: Sort Not Working? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Reports ignore the sort order of the record source. You MUST open the report in design view, specify the desired sort order in the Sorting and Grouping windows, then save the report design. Does that fix your problem?
    (If the report displays the records in the desired order without having specified it in the Sorting and Grouping window, it is by accident, you can't rely on it, as you have found.)

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,869
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort Not Working? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I knew that!

    The following in Report_Open quickly sovled the problem

    Me.RecordSource = gloGetValue("ReportRecordSource")
    Me.OrderBy = gloGetValue("OrderBy")
    Me.OrderByOn = True

    Thanks, John

    PS: Your not going to believe what I have been getting away with for over two years.

    The way this was working for me in the past was to build a tblResultsBP file of the autonumber

Posting Permissions

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