Connection Connection DocumentType (Document) IdDocumentType,System.Int64 Title,System.String IsActive,System.Boolean ValidFrom,System.DateTime ValidUntil,System.DateTime 30 DocumentType (Document) Connection select * from [Document].[DocumentType] Incoming cnt,System.Int32 30 False Incoming Connection grpID,grpID,8,0 FromDate,FromDate,4,0 ToDate,ToDate,4,0 SELECT COUNT(*) as cnt FROM [Docman].[Document].[Document] doc LEFT JOIN [Docman].[Document].[Protokollo] ptc ON doc.IdDocument=ptc.IdDocument WHERE doc.IdDocumentType=1 AND doc.IssueDate>=@FromDate AND doc.IssueDate<=@ToDate AND ptc.IdOrgGroup IN ({GrpsLst}) Outgoing cnt,System.Int32 30 False Outgoing Connection grpID,grpID,8,0 FromDate,FromDate,4,0 ToDate,ToDate,4,0 SELECT COUNT(*) as cnt FROM [Docman].[Document].[Document] doc LEFT JOIN [Docman].[Document].[Protokollo] ptc ON doc.IdDocument=ptc.IdDocument WHERE doc.IdDocumentType=2 AND doc.IssueDate>=@FromDate AND doc.IssueDate<=@ToDate AND ptc.IdOrgGroup IN ({GrpsLst}) Drafts cnt,System.Int32 30 False Drafts Connection grpID,grpID,8,0 FromDate,FromDate,4,0 ToDate,ToDate,4,0 SELECT COUNT(*) as cnt FROM [Docman].[Document].[Document] doc LEFT JOIN [Docman].[Document].[Protokollo] ptc ON doc.IdDocument=ptc.IdDocument WHERE doc.IdDocumentType=3 AND doc.IssueDate>=@FromDate AND doc.IssueDate<=@ToDate AND ptc.IdOrgGroup IN ({GrpsLst}) FEA cnt,System.Int32 30 False FEA Connection grpID,grpID,8,0 FromDate,FromDate,4,0 ToDate,ToDate,4,0 SELECT COUNT(*) as cnt FROM [Docman].[Document].[Document] doc LEFT JOIN [Docman].[Document].[Protokollo] ptc ON doc.IdDocument=ptc.IdDocument WHERE doc.IdDocumentType=4 AND doc.IssueDate>=@FromDate AND doc.IssueDate<=@ToDate AND ptc.IdOrgGroup IN ({GrpsLst}) ,grpID,Κωδικός_x0020_,System.Int32,_x0030_,False,False ,FromDate,Από_x0020_Ημερομηνία,,System.DateTime,,False,False,True ,ToDate,Εώς_x0020_Ημερομηνία,,System.DateTime,,False,False,True ,GrpsLst,Κωδικοί_x0020_Υπηρεσιών,System.Object,,False,False ,usrID,Κωδικός_x0020_Χρήστη,System.Int32,,False,False EngineV2 Incoming.Connect(); Outgoing.Connect(); Drafts.Connect(); FEA.Connect(); None;Black;2;Solid;False;4;Black Transparent Transparent True True 0.2,2,27.2,3.6 Arial,8 True 0,0,0,0 Text2 Ημερομηνία Παραγωγής Αναφοράς : {Time} Από Ημερομηνία : {FromDate} Εώς Ημερομηνία : {ToDate} Κωδικός Υπηρεσίας Που Παρήγαγε Την Αναφορα : {grpID} Κωδικός Χρήστη Που Παρήγαγε Την Αναφορα : {usrID} Black Expression 95, 95, 95 GradientBrush,[255:255:255],[255:255:255],90 100, 95, 95, 95 100, 95, 95, 95 Silver Gainsboro False 100, 95, 95, 95 100, 95, 95, 95 [10:145:145:145] [10:145:145:145] 1 95, 95, 95 Tahoma,8 95, 95, 95 95, 95, 95 Tahoma,8 95, 95, 95 95, 95, 95 Tahoma,8 95, 95, 95 95, 95, 95 Tahoma,8 Left 95, 95, 95 [255:255:255] 17.8,5.8,9.6,8 False

95, 95, 95 GradientBrush,[255:255:255],[255:255:255],90 Arial,8 95, 95, 95 10, 10 95, 95, 95 Arial,14,Bold

Chart2 False 28, 45, 65 GlareBrush,[128:145:165],[178:195:215],0,0.5,1 Firebrick Εισερχόμενα;Εξερχόμενα;Σχέδια;ΦΕΑ {Incoming.cnt};{Outgoing.cnt};{Drafts.cnt};{FEA.cnt} 95, 95, 95 WhiteSmoke Arial,7 95, 95, 95 8, 6 - 0 Black True 95, 95, 95 WhiteSmoke Arial,7 95, 95, 95 8, 6 - 0