This discussion is archived
5 Replies Latest reply: Feb 20, 2013 6:08 PM by user10675696 RSS

report problem

user10675696 Newbie
Currently Being Moderated

I have report which is having two columsn,

job startdate, job id
01-Feb-2013 06:12:33 AM,121
02-Feb-2013 08:30:00 PM,122
01-Feb-2013 11:30:00 PM,121
02-Feb-2013 09:12:33 AM,122
03-Feb-2013 11:30:00 PM,123
03-Feb-2013 1:12:33 PM,123

i have multiple rows in same report as i mentioned above .

for single job will have multiple rows on same day, but my requirement is to show only one(i.e. first record on single day) row for job

Ex: 01-Feb-2013 06:12:33 AM,121
02-Feb-2013 09:12:33 AM,122
03-Feb-2013 1:12:33 PM,123

can you please share any idea for this requirement


  • Correct Answers - 10 points
  • Helpful Answers - 5 points