Report needed for Document Count by Category

Gayle_Waxon_(x-stmgr1_-_(deleted))

I need to write a LiveReport that will count all documents (not folders, or anything else) by Category. Similar to "item count by category" but I only want documents to be counted. I had this report in 8.13, but it doesn't work for 9.1.

***_****_(citlon01admin_-_(deleted))

You can add a parameter to filter on document then add to your where clause "and %3" for the thirst parameter. You could also add the following to the where:where dtree.subtype = 144Subtype 144 is a document.Enjoy ...David Loffhagen