Journaux Journaux C:\Users\GeneraFi\Desktop\Classeur2.xlsx Journal CodeJournal,System.String Intitulejournal,System.String Reference,System.String DateEcriture,System.DateTime id_Ecriture,System.Double Jour,System.Double CodeJournal_1,System.String NumPiece,System.Double Compte,System.Object CodeAux,System.Object LibelleEcriture,System.String Debit,System.Nullable`1[System.Double] Credit,System.Nullable`1[System.Double] Journal Journaux.Journal ,ReportSum,ReportSum,,System.Double,_x0030_,False,False,False,False ,SumDebit,SumDebit,,System.Double,_x0030_,False,False,False,False ,ReportSumCredit,ReportSumCredit,,System.Double,_x0030_,False,False,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,20,2.2 AdvWhite;1;None;White;3;None;White;1;None;White;1;None;False;2;Black [255:255:255] 15,0.2,4.8,0.6 Century Gothic,8,Bold fc48838538714e9d95a68f7ac27bab45 Right 0,0,0,0 Text1 Edition le: {Time} Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 5.4,0.8,9.4,1 Century Gothic,18,Bold 02104acec3254bdfa2ff593f183eb440 Center 0,0,0,0 Text38 Journaux Black Expression Center 9c0b2f9b691544168a05be65d611d2f4 PageHeaderBand1 {Journal.Intitulejournal} Transparent 0,3.4,20,1.2 Transparent 0,0.6,20,0.6 Century Gothic,12,Bold 545a3967ccc942c283ecf0ead3110edd Center 0,0,0,0 Text2 {Journal.CodeJournal} {Journal.Intitulejournal} Black Expression {Journal.Intitulejournal} e43205d71fec4c87a2f53efd487f9931 True GroupHeaderBand2 True True True {(Format("{0:MMMM}", Journal.DateEcriture)).ToString().ToUpper()} {Format("{0:yyyy}", Journal.DateEcriture)} Transparent 0,5.4,20,1.6 Transparent 0,0,20,0.6 Century Gothic,10 7c14fca8bd8c45078a93234dc2c94242 Center 0,0,0,0 Text35 {(Format("{0:MMMM}", Journal.DateEcriture)).ToString().ToUpper()} {Format("{0:yyyy}", Journal.DateEcriture)} Black Expression All;Black;1;Solid;False;2;Black [165:165:165] 0,1,1.2,0.6 Century Gothic,8,Bold 5b9f0bbd58434ffda56d620a81df9bf9 Center 0,0,0,0 Text4 Jour Black Expression Center All;Black;1;Solid;False;2;Black [165:165:165] 2.4,1,1.6,0.6 Century Gothic,8,Bold f3f21b01fa1541419737f86693a1afb5 Center 0,0,0,0 Text3 Référence Black Expression Center All;Black;1;Solid;False;2;Black [165:165:165] 4,1,2.6,0.6 Century Gothic,8,Bold fa5179c5d02b49aaa571a4cf4bc5832f Center 0,0,0,0 Text5 Compte Black Expression Center All;Black;1;Solid;False;2;Black [165:165:165] 9.2,1,6,0.6 Century Gothic,8,Bold c77f9a1228b84f7f87ff51b947cd30b2 Center 0,0,0,0 Text7 Libellé Ecriture Black Expression Center All;Black;1;Solid;False;2;Black [165:165:165] 1.2,1,1.2,0.6 Century Gothic,8,Bold 2be50d0e703047a59e2e41e3d6b860c5 Center 0,0,0,0 Text8 Pièce Black Expression Center All;Black;1;Solid;False;2;Black [165:165:165] 17.6,1,2.4,0.6 Century Gothic,8,Bold d29b32bdce624ed7831e8f2c430218d5 Center 0,0,0,0 Text6 Crédit Black Expression Center All;Black;1;Solid;False;2;Black [165:165:165] 15.2,1,2.4,0.6 Century Gothic,8,Bold 92e669c7bffc4846a84c61ec1655b09a Center 0,0,0,0 Text9 Débit Black Expression Center All;Black;1;Solid;False;2;Black [165:165:165] 6.6,1,2.6,0.6 Century Gothic,8,Bold e1d98bdf1cfd468ab12fb694dd1b0ecb Center 0,0,0,0 Text10 Auxiliaire Black Expression Center All;Black;1;Solid;False;2;Black [183:221:232] 0,1.6,1.2,0.4 _x007B_ReportSum_x0020__x003D__x003D__x0020_0_x007D_,[255:255:255],[255:255:255],Arial_x002C_8,False,False,,,All Arial,8,Bold 070e3038caa9497e91b45bc3bdee9600 3,0,0,0 Text27 Black Expression Center All;Black;1;Solid;False;2;Black [183:221:232] 2.4,1.6,1.6,0.4 _x007B_ReportSum_x0020__x003D__x003D__x0020_0_x007D_,[255:255:255],[0:255:255:255],Arial_x002C_8,False,False,,,All Arial,8,Bold a543a0c9e6b742a3a88997cc0f75bbc5 3,0,0,0 Text28 Black Expression Center All;Black;1;Solid;False;2;Black [183:221:232] 4,1.6,2.6,0.4 _x007B_ReportSum_x0020__x003D__x003D__x0020_0_x007D_,[255:255:255],[0:255:255:255],Arial_x002C_8,False,False,,,All Arial,8,Bold f1aa563a97404c67831790f3b4fb8feb 3,0,0,0 Text29 Black Expression Center All;Black;1;Solid;False;2;Black [183:221:232] 9.2,1.6,6,0.4 _x007B_ReportSum_x0020__x003D__x003D__x0020_0_x007D_,[255:255:255],[0:255:255:255],Arial_x002C_8,False,False,,,All Century Gothic,8,Bold d2f83bfb3b094b8a913612880794b9a0 3,0,0,0 Text30 Report Black Expression Center All;Black;1;Solid;False;2;Black [183:221:232] 1.2,1.6,1.2,0.4 _x007B_ReportSum_x0020__x003D__x003D__x0020_0_x007D_,[255:255:255],[0:255:255:255],Arial_x002C_8,False,False,,,All Arial,8,Bold 28174ebf157443d6bf842d2c2cc279e8 3,0,0,0 Text31 Black Expression Center All;Black;1;Solid;False;2;Black [183:221:232] 17.6,1.6,2.4,0.4 _x007B_ReportSum_x0020__x003D__x003D__x0020_0_x007D_,[255:255:255],[0:255:255:255],Arial_x002C_8,False,False,,,All Century Gothic,8,Bold c652f29df8d9434aa6b674043830ade7 Right 3,3,0,0 Text32 Black n2 Expression Center All;Black;1;Solid;False;2;Black [183:221:232] 15.2,1.6,2.4,0.4 _x007B_ReportSum_x0020__x003D__x003D__x0020_0_x007D_,[255:255:255],[0:255:255:255],Arial_x002C_8,False,False,,,All Century Gothic,8,Bold abec29a213954e2c9c07df24d80dd1f3 Right 0,3,0,0 Text33 Black n2 Expression Center All;Black;1;Solid;False;2;Black [183:221:232] 6.6,1.6,2.6,0.4 _x007B_ReportSum_x0020__x003D__x003D__x0020_0_x007D_,[255:255:255],[0:255:255:255],Arial_x002C_8,False,False,,,All Arial,8,Bold 0945a95fb1014560b9d4315b04b9a96f 3,0,0,0 Text34 Black Expression Center {Journal.DateEcriture.Month} c5ae694685734a7a81320a780a02085f True GroupHeaderBand1 True True True Transparent 0,7.8,20,0.6 All;Black;1;Solid;False;2;Black White 0,0,1.2,0.6 Century Gothic,8 b8cf72613e1745ecaf964556d65978fc Center 0,0,0,0 Text11 {Journal.Jour} Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;2;Black White 2.4,0,1.6,0.6 Century Gothic,8 498cf443a8e145a2b001def87ab2fabe Center 0,0,0,0 Text12 {Journal.Reference} Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;2;Black White 4,0,2.6,0.6 Century Gothic,8 f0bd908d78794e35a92505836e76cb40 Center 0,0,0,0 Text13 {Journal.Compte} Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;2;Black White 9.2,0,6,0.6 Century Gothic,8 26f6500c1815406e8d5220b92406e950 3,0,0,0 Text14 {Journal.LibelleEcriture} Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;2;Black White 1.2,0,1.2,0.6 Century Gothic,8 0b9217cf1b4f417281479310601ae3da Center 0,0,0,0 Text15 {Journal.NumPiece} Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;2;Black White 6.6,0,2.6,0.6 Century Gothic,8 a3aef69e56854e28babeac9f5308f38c Center 0,0,0,0 Text18 {Journal.CodeAux} Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;2;Black White 17.6,0,2.4,0.6 Century Gothic,8 24cd0158b14c41798289a4210a88fa5e Right 0,3,0,0 Text36 {Journal.Credit} Black n2 ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;2;Black White 15.2,0,2.4,0.6 Century Gothic,8 f5552745caf446699be67c457ec82b4b Right 0,3,0,0 Text37 {Journal.Debit} Black n2 ,,,,WordWrap=True,A=0 Expression Center Journal e56a4d0510b844c282947ab99592be2f True KeepDetailsTogether DataBand1 ASC Jour ASC CodeJournal ASC id_Ecriture Transparent 0,9.2,20,0 df517b78c2344fe39425ab20bbd24d96 False FooterBand1 True False ReportSum = 0; ReportSumCredit =0 ; Transparent 0,10,20,0.4 All;Black;1;Solid;False;2;Black [216:216:216] 17.6,0,2.4,0.4 Century Gothic,8,Bold 22918c61886e4b7da79c3fa7d3ae9532 Right 0,3,0,0 Text54 {SumRunning(GroupHeaderBand1,Journal.Credit)} Black n2 Totals Center All;Black;1;Solid;False;2;Black [216:216:216] 15.2,0,2.4,0.4 Century Gothic,8,Bold 0b80bcc7ce314944be7374a542caca50 Right 0,3,0,0 Text55 {SumRunning(GroupHeaderBand1,Journal.Debit)} Black n2 Totals Center All;Black;1;Solid;False;2;Black [216:216:216] 2.4,0,1.6,0.4 Arial,8,Bold ae88b839b67046b895788343d1a1e4b4 Center 0,0,0,0 Text40 Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 4,0,2.6,0.4 Arial,8,Bold 5cb33093cd284e13ae6cb04699df5207 Center 0,0,0,0 Text41 Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 9.2,0,6,0.4 Century Gothic,8,Bold e5c5040c97ae4d45a1dbb365456b1345 3,0,0,0 Text42 Sub Total (Need to be repeat on each page) Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 1.2,0,1.2,0.4 Arial,8,Bold 071644cf8d2b46ada86abbe788990b35 Center 0,0,0,0 Text43 Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 6.6,0,2.6,0.4 Arial,8,Bold 17797afed4ad4a1eb307cf2ded8cf579 Center 0,0,0,0 Text44 Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 0,0,1.2,0.4 Arial,8,Bold ec5f3849e587491daea6a74f06f17898 Center 0,0,0,0 Text39 Black Expression Center 870a40a675034e1eae2dbef4ca9b91e0 False GroupFooterBand1 ReportSum = 0; ReportSumCredit = 0; Transparent 0,11.2,20,0.4 All;Black;1;Solid;False;2;Black [216:216:216] 0,0,1.2,0.4 Arial,8,Bold 38950fcd4ec74c86ae3819ce1051ab10 Center 0,0,0,0 Text19 Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 2.4,0,1.6,0.4 Arial,8,Bold 8e5bc8c48780494b93137612650e13b3 Center 0,0,0,0 Text20 Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 4,0,2.6,0.4 Arial,8,Bold ae5e480bcc824353b8c12f2d1feb9bdf Center 0,0,0,0 Text21 Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 9.2,0,6,0.4 Century Gothic,8,Bold 27e3e77a7eff431f9c541ab074eeb3dc 3,0,0,0 Text22 Total journal du Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 1.2,0,1.2,0.4 Arial,8,Bold 7a1938ddfae14774af0600adb820b0c0 Center 0,0,0,0 Text23 Black Expression Center All;Black;1;Solid;False;2;Black [216:216:216] 17.6,0,2.4,0.4 Century Gothic,8,Bold 8ddb04df4917409296b2d95fd27386ec Right 0,3,0,0 Text24 {SumRunning(GroupHeaderBand2,Journal.Credit)} Black n2 Totals Center All;Black;1;Solid;False;2;Black [216:216:216] 15.2,0,2.4,0.4 Century Gothic,8,Bold 028a16fa0c3449b3a204778655fe6028 Right 0,3,0,0 Text25 {SumRunning(GroupHeaderBand2,Journal.Debit)} Black n2 Totals Center All;Black;1;Solid;False;2;Black [216:216:216] 6.6,0,2.6,0.4 Arial,8,Bold b9ea9dab212b4ad2b103b1ee9ec8475c Center 0,0,0,0 Text26 Black Expression Center Journal.CodeJournal,EqualTo,_x0030_0AN,,String,[255:0:0],[0:255:255:255],Arial_x002C_8,False,False,,,None 50ccad0f85b3400f9be2d425d3384398 GroupFooterBand2 609fc08300e84b36a02e29e6f1cdbd1c 0.5,0.5,0.5,0.5 Page1 29.7 21 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 3/29/2018 4:28:12 PM 3/29/2018 3:55:29 PM 7cebc21fd9aa4629b480c5e44feffb7a Report Centimeters 2018.1.8.0 CSharp