Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Graph Order by Display/Value Post Reply Post New Topic
Author Message
msheppard
Newbie
Newbie


Joined: 01 Jul 2011
Online Status: Offline
Posts: 1
Quote msheppard Replybullet Topic: Graph Order by Display/Value
    Posted: 01 Jul 2011 at 5:29am
Is it possible to sort a grouping in a graph by a value but display a string?

Specifically time - I've got a graph that groups by an HOUR value that's formatted like this:
ToText( MyTime, "h:mm tt","am","pm")


The problem is the sorting shows up like this, sorted alphabetically:

    10:00 am
    10:00 pm    
    11:00 am
    11:00 pm
    etc...

One solution I have is to format to military time (HH:mm) - but this isn't a military application.
      
      IP IP Logged
      Post Reply Post New Topic
      Printable version Printable version

      Forum Jump
      You cannot post new topics in this forum
      You cannot reply to topics in this forum
      You cannot delete your posts in this forum
      You cannot edit your posts in this forum
      You cannot create polls in this forum
      You cannot vote in polls in this forum



      This page was generated in 0.031 seconds.