Help needed with the report

[reacha]

I have a report in which first i have grouped by supervisorname,username,auditdate,pkgid

Now i need to get only 2 pkgid's for each username they should be on different dates

For Ex:

Supervisor Username Auditstamp pkgid
---------- --------- ---------- ------
TOM Peter 11/30/2010 10000
11/31/2010 10001
12/05/2010 10005

Adam james 12/01/2010 10010
10012
12/05/2010 10014

Output should be
----------------

Supervisor Username Auditstamp pkgid
---------- --------- ---------- ------
TOM Peter 11/30/2010 10000
11/31/2010 10001

Adam james 12/01/2010 10010
12/05/2010 10014


Thanks,
reacha

 

[Turkbear]

Hi,
What determines which 2 pkgid entries you want to show?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[reacha]

Any two pkgid's for any dates so that they want to quality audit process on that

 

[reacha]

i want the 2 pkgid's which are random with the corresponding dates





Please help me out!!



Thanks,
reacha