How many documents are in a folder and its subfolders

Dimitri__Vanderheyde_(x-efsbruadmin_-_(deleted))

Our folders are grouped according to the various departments. I would like to write a LiveReport that gives the total number of documents in a folder and its subfolders grouped by department. For example, I would a number of all the documents in the Finance area then Communications, HR etc. I have written something but it does not work well. I have searched this Discussion but found nothing that could help me. Thanks.

Dave_Ebels_(jocoadmin_-_(deleted))

I use a live report to count files in a folder, and subsequent child or sub folders. The SQL in the live report is; select count(datasize)"File count" from dversdata where docid in (select dataid from dtree start with dataid in () connect by prior dataid=parentid)Remove and add your folder object ID. The report returns a file count using the parent object ID as a starting point. You can add as many object ID's as you like, seperated with commas. This only gives a file count, so I have created several live reports, named for the department, and I simply run them, copy & paste the results into excel and move to the next report. It does not take long, and I can look at a specific department any time I like.Another interestig tool I use is an adaptation of the 'Project Outline' feature. I created a URL object in my personal workspace and called it 'xyz folder outline'. In the URL added I placed the following ?func=Projects.ProjectOutline&objid=xxxxxx&ItemType_144=&ItemType_0=where again I add the object ID (xxxxxx) of a folder I want an outline for. Replace the x's with a folder object ID and run it. I hope these help!Dave EbelsJohnson Controlsdave.j.ebels@jci.com