This report is included in your XBOUND installation – see description in XBOUND Help.
How many root documents were processed in a process step, and how long did it take to process all of those documents in the step?
SELECT Client, Process, ProcessStep,
SUM(CheckOutDurationHours) AS Time,
AVG(CheckOutDurationHours) AS TimeAvg,
COUNT(DISTINCT DocumentID) AS DocumentCount,
RepCatName,
CASE RepCatName WHEN ' ' THEN '<not assigned> ' ELSE RepCatName END AS CatDisplayName
FROM V_StepsReports
WHERE (ProcessStep IN (@strProcessStep))
AND (DateOnly BETWEEN @StartDate AND @EndDate)
AND (Client IN (@strClient))
AND (Process IN (@strProcess))
AND (Action <> 'CheckOut')
AND (Action <> 'RoutedManually')
AND (CASE DocumentType WHEN ' ' THEN '<not assigned>' ELSE DocumentType END IN
@DocumentType))
AND (CASE RepCatName WHEN ' ' THEN '<not assigned> ' ELSE RepCatName END IN
(@RepCatName))
GROUP BY Client, Process, ProcessStep, RepCatName
Process
step (@strProcessStep)
Reporting
category (@RepCatName)
Start
date / End date (@StartDate / @EndDate)
The document type selection list includes a "not assigned" option. Otherwise there would be an empty spot there and the user would not understand why.
DISTINCT CASE DocumentType WHEN ' ' THEN '<not assigned> ' ELSE DocumentType END
The same is true for reporting category.
The "CheckOut" and "RoutedManually" actions do not need to be considered because they do not have times associated with them.
The number of root documents needs to be determined. Since V_StepsReports only contains root documents, the different DocumentID's can be counted (count distinct).
Tip: Root documents and sub-documents are saved in W_Document. The connection can be made using ParentID.
Total: This number is the sum of all documents in the different process steps. The number does not tell you how many documents were processed, because the same document can be processed in different process steps. Rather, this number tells you how many documents were processed by the process steps.
Sample report: Capture Statistics
Sample report: Detailed Capture Statistics
Sample report: Sheet Page Image Per Process Step