Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How to display the First Record of the sorted data Post Reply Post New Topic
Author Message
SIddhu
Newbie
Newbie
Avatar

Joined: 27 Feb 2008
Location: India
Online Status: Offline
Posts: 22
Quote SIddhu Replybullet Topic: How to display the First Record of the sorted data
     Posted: 13 Jun 2008 at 2:18am

   I have to display the First record from the sorted data in the crystal reports.

Acutally the thing is :  i have lotsa dates available in the Database from which i av to take the oldest date, which i planned to get by first sorting the dates in ascending order and picking the first date as the oldest date.
 
There are Representatives who have lotsa activities for which there is a date_of_completion. so i hve to display the oldest date of completion for each and every Representative listed in the report. the output will kinda look like this :
 
Representative      Cnt of Activities         Oldest_Date
-------------------     -----------------------      ----------------
ADAM_SCHMIDT           190                 2006-10-02 00:00:00.000
ADMIN                              4                 2006-11-28 00:00:00.000
ALESIA_QUINCY               2                 2007-11-27 00:00:00.000
AMANDA_SHREKENGOS    2                 2008-02-01 00:00:00.000
AMINA_RAHEIM                1                 2008-04-21 00:00:00.000
ANDREW                          1                 2006-11-08 00:00:00.000
ANDREW_CORRAO         57                2006-10-10 00:00:00.000
ANGELA_GOULD               1                2007-11-05 00:00:00.000
 
If the solution i decided wont work out welll, then can anyone suggest me any easier way to get that ouput.....
 
Thanks in advance....
Siddhu.
Thanks,
Siddhu.
IP IP Logged
Zorgov
Newbie
Newbie
Avatar

Joined: 23 Apr 2008
Location: Canada
Online Status: Offline
Posts: 12
Quote Zorgov Replybullet Posted: 13 Jun 2008 at 7:52am
Hi Siddhu
 
What i would do is display all the representatives, activities and dates in the detail.
 
Then group by representative.
then in the group footer, i would put :
the representative name (group name)
distinct count of activities (a summary)
minimum of date (a summary) (it will take the smallest date)
 
then you suppress the detail and the group header and you will see exactly what you are looking for.
 
hope this will help!
IP IP Logged
SIddhu
Newbie
Newbie
Avatar

Joined: 27 Feb 2008
Location: India
Online Status: Offline
Posts: 22
Quote SIddhu Replybullet Posted: 03 Jul 2008 at 10:16pm
Hi !!
 
I tried your solution and it worked...
Thanks a lot  !!
Thanks,
Siddhu.
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