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.