Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Posts
    64

    Unanswered: Grouping Months ASC via report

    Trying to show report in ascending order by months, like, Jan, Feb, Mar and Apr, you get the point.
    But it’s showing Apr, Feb, etc.
    No problem from the query, but the report is wrong. I put the months from the query in ascending order, still the same problem.

    Please advise...

  2. #2
    Join Date
    Aug 2003
    Posts
    64
    darn..
    now the query doing it,
    what's the problem?
    please help..

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    That's because you're ordering on an alphabetic sequence. You need to setup a hidden numeric sequence to order on ...

  4. #4
    Join Date
    Aug 2003
    Posts
    64
    Originally posted by M Owen
    That's because you're ordering on an alphabetic sequence. You need to setup a hidden numeric sequence to order on ...
    OK, could someone provide an example.

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by comf36
    OK, could someone provide an example.
    How much of a sample do you need?

    Jan 1
    Feb 2
    ....

    When you query for your month, create another column that has the numeric month to order by ...

  6. #6
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    depending on where your months come from (type=text or type=Date/Time) you might also want to consider the month() function

    month(anyValidDateTimeType) returns 1, 2, ... 12 as you would expect... and you could sort by that.

    izy
    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
  •