Sample report: Sheet Page Image Per Process Step

This report is included in your XBOUND installation – see description in XBOUND Help.

Question

How many root documents and sub-documents, sheets, pages, and images were processed in a process step?

SELECT Client, Process, ProcessStep,

SUM(SheetCount) AS SumSheet,

SUM(PageCount) AS SumPage,

SUM(ImageCount) AS SumImage,

SUM(DocCount) AS SumDoc,

COUNT(DISTINCT BatchID) AS SumBatch

FROM V_ShPaImPerProcessStep

WHERE (DateOnly BETWEEN @StartDate AND @EndDate)

AND (Client IN (@strClient))

AND (Process IN (@strProcess))

AND (UserName IN (@UserName))

GROUP BY Client, Process, ProcessStep

V_ShPaImPerProcessStep is derived from W_DocHistory and V_StepsReports.
W_DocHistory is only populated when Save history is selected for the document type.
Why W_DocHistory? Every step that the document is processed in is saved here. Changes can be traced. The number of sheets, pages, and images is also saved, and here, too, changes can be traced.
Also, checking the number of sheets per W_Sheets does not include changes. It only checks the current number. (The same goes for W_Page und W_Image.)
Why V_StepsReports? All of a document's process steps are saved in this view. The assignment to the process step, process, and client are also here.
The number of documents includes the root documents and sub-documents. This can be determined because the sub-documents are also saved in the W_DocHistory table.
DocumentID <> BatchID
This report does not give you a grand total, because since it is not about the sum of the various documents. Rather, you see how many root documents and sub-documents were processed per process step. See Data contexts.