Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Count Duplicate values and display Post Reply Post New Topic
Author Message
rp1234
Newbie
Newbie


Joined: 15 Dec 2011
Online Status: Offline
Posts: 4
Quote rp1234 Replybullet Topic: Count Duplicate values and display
     Posted: 16 Dec 2011 at 6:43pm
Hi,

I have the following data sample:

00:00:00
00:00:00
00:00:01
00:00:01
00:00:01
00:00:01
00:00:22
00:00:22

How can i count the same time values and display like this:

Time                    Counts
00:00:00                     2
00:00:01                     3
00:00:22                     2

These 00:00:00 etc are TIME values.

Please help.
thx
Raj
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Dec 2011 at 10:15am
Group on the value, set the group to per second
Insert a count of the field ay the group footer
Move the count to the header
Suppress the details and footer
IP IP Logged
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