I am working on a search report for a database using Crystal Reports. What I would like to do is display the top 10 users who logged into the system. It would look something like this:
Username Number of times logged in
Smith00 9
Brown88 5
Joe2321 3
The information is read out of a Log table that records the username and other data everytime someone logs in. How can I do this? Would the TopN function work? Thanks!
Username Number of times logged in
Smith00 9
Brown88 5
Joe2321 3
The information is read out of a Log table that records the username and other data everytime someone logs in. How can I do this? Would the TopN function work? Thanks!