help needed in report

[reacha]

The same case as i posted earlier
(Need to get the first record from the third group)

but in this report i have group by username and then group by accountnumber and pkgid. now i have the
count({command.pkgid},{command.pkgid}) i need to get the username and accountnumber,pkgid when the count >=2

for ex:

UserName AccountNumber pkgid count
-------- ------------- ------ ------
Tom 2000 11111 2
22222 2
george 2001 33333 1
peter 1000 44444 2
55555 1

output should be
----------------

Tom 2000 11111 2
22222 2
peter 1000 44444 2

Please help me out with this

Thanks,
reacha

 

[lbass]

Go to report->selection formula->GROUP and enter:

count({command.pkgid},{command.pkgid}) >= 2

Participating in Tek-Tips implies both getting help and giving help, and so far you have only asked for assistance. Please consider contributing to others by responding to their threads when you can help.

-LB

 

[reacha]

Thanks lbass.

Surely,I will help others by responding to there threads if i know the answer



Thanks,
Rupa