users and documents

Birger_Jacobsen_(danskadmin_-_(deleted))

I need help to create a LR to find who has uploaded most documents (only number) in which folder (Name).following is a first attempt but I get only the number and in a specific folderselect count(*) As "Number of documents" from dtree where subtype=144 start with dataid=(select distinct abs(dataid) from dtree where dtree.DATAID = %1) connect by prior dataid=abs(parentid) group by to_char(status) %1 user input Type : ContainerThanks for help

Sander_van_der_Moolen_(verkeeruser1_-_(deleted))

I'm not an "sql buff" so it took me a bit of time (i don't have the ll schema either, i'll have to make a request to Opentext for that :-)), but this is what i could figure out so far:select count(dtree.subtype) "Counter", kuaf.firstname, kuaf.lastname from dtree, kuaf where dtree.subtype=144 and dtree.parentid=%1 and dtree.userid=kuaf.id group by kuaf.lastname, kuaf.firstname order by count(dtree.subtype) desc;%1 user inputType: ContainerAutolivereportNow, i tested this statement against an Mssql db and it works, but you may need to modify a bit for Oracle.This report will have you select a folder, and will then show you the number of documents that a user has uploaded to it.hope this helps!Sander."Who is this General Failure and why is he reading my disk?"