Exempelrapport: Production Summary Report

SELECT Client, Process,

(SELECT COUNT(DISTINCT FieldID) AS Expr1

FROM V_InteractiveField AS Sel1

WHERE (ProcessID = V_StepsDocReport.ProcessID) AND (FieldEvaluation < 4)) AS FieldCount,

(SELECT SUM(Substitutions + SuggestionFaulty) AS FCo

FROM V_InteractiveStepsDocReport

WHERE (ProcessID = V_StepsDocReport.ProcessID)) AS FieldCorr,

(SELECT SUM(SuggestionCorrect) AS FCon

FROM V_InteractiveStepsDocReport AS V_InteractiveStepsDocReport_1

WHERE (ProcessID = V_StepsDocReport.ProcessID)) AS FieldConf COUNT(DISTINCT DocID) AS DocCount,

SUM(CASE WHEN BatchID = DocID THEN CurrentSheetCount ELSE 0 END) AS SheetCount,

SUM(CASE WHEN BatchID = DocID THEN CurrentPageCount ELSE 0 END) AS PageCount,

(SELECT SUM(CASE WHEN BatchID = DocID THEN InterActiveTimeSum / 3600 ELSE 0 END) AS Expr1 FROM V_InteractiveStepsDocReport AS Sel1

WHERE (V_StepsDocReport.ProcessID = ProcessID)) AS Time,

(SELECT AVG(CASE WHEN BatchID = DocID THEN InterActiveTimeSum / 3600 ELSE 0 END) AS Expr1

FROM V_InteractiveStepsDocReport AS Sel1

WHERE (V_StepsDocReport.ProcessID = ProcessID)) AS TimeAvg

FROM V_StepsDocReport

WHERE ((CASE WHEN ParentID = 0 THEN (CASE WHEN OriginalDocName IS NULL

THEN '<not assigned>' WHEN OriginalDocName = '<only sub document types>' THEN ' ' ELSE OriginalDocName END) END) IN (@OriginalRootDocumentType) OR

(CASE WHEN ParentID <> 0 THEN (CASE WHEN OriginalDocName IS NULL

THEN '<not assigned>' WHEN OriginalDocName = '<only sub document types>' THEN ' ' ELSE OriginalDocName END) END) IN (@OriginalSubDocumentType)) AND

(Client IN (@strClient)) AND (Process IN (@strProcess)) AND (DocCreateDateOnly BETWEEN @StartDate AND @EndDate)

GROUP BY Client, ProcessID, Process