Print Page | Close Window

Graph Order by Display/Value

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13655
Printed Date: 05 May 2024 at 4:25am


Topic: Graph Order by Display/Value
Posted By: msheppard
Subject: Graph Order by Display/Value
Date 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.
      


      Print Page | Close Window