Connection Connection Ekkrem IdWorkflow,System.Int32 Status,System.Int32 Title,System.String IssueDate,System.DateTime DocKind,System.String DocType,System.String IdDocumentKind,System.Int32 IdDocumentType,System.Int32 ArPrApostolea,System.String ProtocolText,System.String IdCreatedByGroup,System.Int32 Apostoleas,System.String CreatorName,System.String CreatorSurname,System.String AuthorName,System.String AuthorSurname,System.String 30 False Ekkrem Connection grpID,grpID,8,0 FromDate,FromDate.ToString_x0028__x0022_dd_x002F_MM_x002F_yyyy_x0022__x0029_,31,0 ToDate,ToDate.ToString_x0028__x0022_dd_x002F_MM_x002F_yyyy_x0022__x0029_,31,0 usrID,usrID,8,0 SELECT IdWorkflow, Status, doc.Title, doc.IssueDate, dk.Title AS DocKind, dt.Title AS DocType, doc.IdDocumentKind, doc.IdDocumentType, doc.ArPrApostolea, ptc.ProtocolText, doc.IdCreatedByGroup, grp.Name AS Apostoleas, user1.Name AS CreatorName, user1.Surname AS CreatorSurname, user2.Name AS AuthorName, user2.Surname AS AuthorSurname FROM [Docman].[Document].[DocumentCopy] dc INNER JOIN [Docman].[Document].[Document] doc ON doc.IdDocument=dc.IdDocument INNER JOIN [Docman].[Document].[DocumentKind] dk ON doc.IdDocumentKind=dk.IdDocumentKind INNER JOIN [Docman].[Document].[DocumentType] dt ON doc.IdDocumentType=dt.IdDocumentType INNER JOIN [Docman].[Organization].[OrgUser] user1 ON user1.IdOrgUser=doc.IdCreatedByUser INNER JOIN [Docman].[Document].[Signature] sgn ON sgn.IdDocument=doc.IdDocument LEFT JOIN [Docman].[Document].[Protokollo] ptc ON doc.IdDocument=ptc.IdDocument LEFT JOIN [Docman].[Organization].[OrgUser] user2 ON user2.IdOrgUser=doc.IdAuthor LEFT JOIN [Docman].[Organization].[OrgGroup] grp ON grp.IdOrgGroup=doc.IdCreatedByGroup WHERE (dc.IdWorkflow=1 OR dc.IdWorkflow=5) AND sgn.IdOrgUser=@usrID AND doc.IssueDate>=@FromDate AND doc.IssueDate<=@ToDate AND (ptc.IdOrgGroup IN (:GrpsLst:) OR ptc.IdOrgGroup=NULL) AND doc.IdDocumentKind IN ({DocKind.ToQueryString()}) ORDER BY doc.IssueDate DESC DocumentKind (Document) IdDocumentKind,System.Int64 Title,System.String IsActive,System.Boolean ValidFrom,System.DateTime ValidUntil,System.DateTime DiavgeiaId,System.Int64 30 DocumentKind (Document) Connection select * from [Document].[DocumentKind] ,FromDate,Από_x0020_Ημερομηνία,Από_x0020_Ημερομηνία,System.DateTime,,False,False,True ,ToDate,Έως_x0020_Ημερομηνία,Έως_x0020_Ημερομηνία,System.DateTime,,False,False,True ,usrID,usrID,System.Int32,,False,False ,grpID,grpID,System.Int32,,False,False ,usrDN,usrDN,System.String,,False,False ,grpDN,grpDN,System.String,,False,False ,DocKind,Είδος_x0020_Εγγράφου,Είδος_x0020_Εγγράφου,Stimulsoft.Report.IntList,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_DocumentKind__Document_.IdDocumentKind_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_DocumentKind__Document_.Title_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,GrpsLst,Λίστα_x0020_Υπηρεσιών,Λίστα_x0020_Υπηρεσιών,System.Object,,False,False,False EngineV2 Ekkrem.Connect() None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,27.7,2.2 None;[59:88:125];1;Solid;False;4;Black Transparent 0,0,27.6,2 Arial,8.25,Regular,Point,False,161 f88330046a3a4f75bd45bec7349cdcda 0,0,0,0 ReportTitleText Τίτλος: Εγγραφα που έχει υπογράψει ο χρήστης Ημ. Δημιουργίας: {Time} Χειριστής : {usrDN} Υπηρεσία : {grpDN} Από Ημερομηνία : {FromDate.ToString("dd/MM/yyyy")} Έως Ημερομηνία : {ToDate.ToString("dd/MM/yyyy")} [0:0:25] Expression 44d9a8957f484e678d8cdf0cc12744fb ReportTitle

Transparent 0,3.4,27.7,0.6 Top, Left, Bottom;[59:88:125];1;Solid;False;4;Black;True [159:188:225] True 0,0,3,0.6 Arial,8,Bold True 8689b74ecbb34b4e927d5352af9b26ac Center 0,0,0,0 HeaderText1 Ημερομηνία Έκδοσης [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True [159:188:225] True 3,0,2.4,0.6 Arial,8,Bold True 5b7ae6f6cb6c45e9b3be7c366672a58c Center 0,0,0,0 HeaderText2 Τύπος / Είδος [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True [159:188:225] True 5.4,0,8.2,0.6 Arial,8,Bold True b20eb36449fd4c1aaa13478608b1d918 Center 0,0,0,0 HeaderText3 Τίτλος [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True [159:188:225] True 13.6,0,3.4,0.6 Arial,8,Bold True 3b5c2de7c3a1430f97fdc2ef7a07a55b Center 0,0,0,0 HeaderText4 Αριθμός Πρωτοκόλλου [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True [159:188:225] True 17,0,2.6,0.6 Arial,8,Bold True 7bc04734baf3438b89db48a1c250ee8a Center 0,0,0,0 HeaderText5 Α. Π. Αποστολέα [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True [159:188:225] True 19.6,0,3.4,0.6 Arial,8,Bold True b83c0503b5f44f1c99f88dbf8dac976f Center 0,0,0,0 HeaderText6 Αποστολέας [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True [159:188:225] True 23,0,2.2,0.6 Arial,8,Bold True 38fb1ad9e86a49cf8b2071cd1ed38d89 Center 0,0,0,0 HeaderText7 Καταχωρητής [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Top, Right, Bottom;[59:88:125];1;Solid;False;4;Black;True [159:188:225] True 25.2,0,2.4,0.6 Arial,8,Bold True a2cbeeb8c90d4ba29dfa80e164d01804 Center 0,0,0,0 HeaderText8 Συντάκτης [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center 88792764364f4583a3045ad0a8f6d3dd Header

Transparent 0,4.8,27.7,0.6 Top, Left, Bottom;[59:88:125];1;Solid;False;4;Black;True Transparent True 0,0,3,0.6 Arial,8 True 4a07cd6c57454ae8b7e4eea52a3831c6 0,0,0,0 DataText1 {Ekkrem.IssueDate} [0:0:25] dd/MM/yyyy HH:mm HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True Transparent True 3,0,2.4,0.6 Arial,8 True a4324d3ff68846fc8d78892869018098 Center 0,0,0,0 DataText2 {Ekkrem.DocType} / {Ekkrem.DocKind} [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True Transparent True 5.4,0,8.2,0.6 Arial,8 True 124bba2fd5cb4238a6e822bb05403608 0,0,0,0 DataText3 {Ekkrem.Title} [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True Transparent True 13.6,0,3.4,0.6 Arial,8 True e455d1a3ddfd46f0b9d5e812d48bef46 0,0,0,0 DataText4 {Ekkrem.ProtocolText} [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True Transparent True 17,0,2.6,0.6 Arial,8 True 07513e4c31da4b51a8a690dc6a62aedf 0,0,0,0 DataText5 {Ekkrem.ArPrApostolea} [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True Transparent True 19.6,0,3.4,0.6 Arial,8 True 4af05431e02b43349270f2b001b10876 0,0,0,0 DataText6 {Ekkrem.Apostoleas} [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Top, Bottom;[59:88:125];1;Solid;False;4;Black;True Transparent True 23,0,2.2,0.6 Arial,8 True c6f023308e4d4bba8cab178e1810054d 0,0,0,0 DataText7 {Ekkrem.CreatorSurname} {Ekkrem.CreatorName} [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Top, Right, Bottom;[59:88:125];1;Solid;False;4;Black;True Transparent True 25.2,0,2.4,0.6 Arial,8 True 3cf00c7283064c2da5a4c0965731fece 0,0,0,0 DataText8 {Ekkrem.AuthorSurname} {Ekkrem.AuthorName} [0:0:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Ekkrem 9e16cede8e8a4c84a86bed96d07ea66a Data 414f2199e69f4a1297cdc72889e4139b 1,1,1,1 Page1 Landscape 21 29.7 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 12/16/2013 11:44:29 AM 11/19/2013 5:53:26 PM D:\Backup\_SOS_\21.mrt 57cea81f6f6b487e973a5e6c92e6eaa6 Report Centimeters 2013.2.1700 True CSharp