how can we find out in HP TRIM / HP RM which user created the most records in the database...
WHo is the recorder?
what that search would look like...
In the HP Trim client Record Statistics can get your there :-
Go - Tools | Reports | Record Statistics Report
Create a new Report
Name = Records Created by Year by Creator
Record Selection method = Date Registered
Start of period = 1/1/2000 (or from whenever you started registering records)
End of period (today)
(Do not select the “Include parts” option)
Period Type = years
Grouped By = Creator
Filter=Choose the record types you consider as "Records" (for example deselect any Box types)
Then right mouse click on the report and choose "Generate Statistics" and after a few seconds Trim will (hopefully!) report statistics generated.
Then right mouse click on the report and choose export to excel
Open in Excel
You get one row per user with each year from 2000 to 2015 as columns and a Total Records column for that user.
Once again, Richie helped!
I've done it exactly as you instructed, worked fine.
Report made and statistic run (I was afraid that it will take so much time, but it actually went pretty quick, 5-10 minutes (I was away from my desk)
I just need to figure out how to make PIVOT table to add totals for each year per each user and voila, sort them out by highest to lowest and we have a winner!
Fantastic work, thanks again.