LiveReport on Object Count within Projects in Livelink 9.1sp3

Edward_Dudetsky_(edudetsky_(Delete)_3648187)

Dear ELinkCan anyone comment on what is the best way of getting multiple Input parameters to work for a LiveReport listhing Object Count by Object Type?I am trying to get Documents, Folders, Compound Documents and documents within compound documents listed within count LiveReport for Projects and I am using Param %1: Inputs: Project: Select ProjectIn addition I am trying to use the following switches for the Node Types Param %2:Inputs:Object:Please select nodeTypeParam %3:Inputs:Object:Please select nodeTypeParam %4:Inputs:Object:Please select nodeTypeThe SQL basis for the above is as below -SELECT (SELECT COUNT(*) FROM dtree WHERE SubType = '0' AND OwnerID = % ) "FOLDERS"AS folders, (SELECT COUNT(*) FROM dtree WHERE SubType = '144' AND OwnerID =%1)"documents", (SELECT COUNT (*) FROM dtree WHERE subType = '144' AND OwnerID IN (SELECT dataID FROM dtree WHERE subType = '136' AND OwnerID =%1)) "Docs_in_CD", (SELECT COUNT(*) FROM dtree WHERE SubType = '136' AND OwnerID=%1) "Compound_documents", (SELECT COUNT (*) FROM dtree WHERE subType = '144' AND OwnerID IN (SELECT dataID FROM dtree WHERE subType = '136' AND OwnerID =%1)) "Docs_in_CD"As you will understand I am trying to replace Param %2: for subType = '0' Param %3: for subType = '144' and etc...The problem is that we would also need to use Sub Live Report for the document items within Compound Documents as per SQL above - (SELECT COUNT (*) FROM dtree WHERE subType = '144' AND OwnerID IN (SELECT dataID FROM dtree WHERE subType = '136' AND OwnerID =%1)) "Docs_in_CD"Does anyone have any suggestions/ ideas on how best to run the above wit5h LiveReport and SubLive Report?Any ideas would be much appreciated.RegardsEdward Dudetsky