Post reply

Need to sort "HH AM/PM" correctly

  • November 13, 2009 at 2:52 pm

    #206463

    Hi,

    I've created a matrix that breaks up stats by the hour as shown on the graphic attached. My challenge has been trying to sort it chronologically i.e. 9 am, 10 am, 11 am, 12 pm, etc.

    If you notice in the graphic, 12 PM is slipping all the way to the bottom. Does anybody have the solution or idea to get around this?

    thx,

    John

  • November 13, 2009 at 3:24 pm

    #1079289

    Never mind, I figured it out; pass the time part of the datetime field in military format to the report from the sproc; then at the report level, sort on the left for 2 chars of such field. It works

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply