Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: sorting time Post Reply Post New Topic
Author Message
bing
Newbie
Newbie


Joined: 25 Aug 2014
Location: Philippines
Online Status: Offline
Posts: 5
Quote bing Replybullet Topic: sorting time
    Posted: 12 Apr 2015 at 2:22am
Hi,

I have a Crystal Report that needs to be sorted by time for 24 hours a day.

Everything is going well except for the time 12 noon to 12:59 PM. When sorted, the 12:00 Noon to 12:59 PM always appears after the 11:00 PM - to 11:59 PM.

Any advise how to make this appear after 11:00 AM - 11:59 AM?

I have 2 groups:
1] Datetime field
2] text of datetime field + company name   

The second group I need to count record under it. Resets to 0 when value changes

When count is 1, print details for a contact field
When count > 1, print "" for a contact field.

Thanks.
Bing
IP IP Logged
bing
Newbie
Newbie


Joined: 25 Aug 2014
Location: Philippines
Online Status: Offline
Posts: 5
Quote bing Replybullet Posted: 13 Apr 2015 at 2:07am
Hi,

Just want to share the answer to my question yesterday regarding sorting time. I just happen to find the answer also yesterday.

Change the system display time to 24-hour setting in the control panel --- regional and time setting. change hh to HH in both short time and long time....
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.016 seconds.