Count of Documents in a Folder and it's Subfolders with Sizes

Chukwudi_Awaibe

Pls can someone help me. I want the report below to generate a count of documents in a folder and its sub folders and the size of documents in them. Currently I get the entire size of the doucments in the folder instaed of the size of the documents in individual folders and subfolders.select d.dataid "Folder ID", d.name "Folder Name", (select count(1) from dtree where parentid=d.dataid and subtype=144) "No. of Docs", (Select SUM(d3.datasize)/(1024 *1024) from dversdata d3, dtree d where d3.docid = d.dataid) "Megabytes" from dtree d where d.subtype = 0 start with d.dataid = %1 connect by prior d.dataid = abs(d.parentid)