Xanthos 4NCx610Foln9BiXs8lxiRvxW/yk= Xanthos Laborbuch bereich,System.String enummer,System.Int32 enummerformatiert,System.String o_nummer,System.Int32 b_nummer,System.Int32 f_kuerzel,System.String o_kuerzel,System.String b_kuerzel,System.String b_text,System.String o_text,System.String f_text,System.String b_Nummer_formatiert,System.String OTLaborbuchNummer,System.String 30 Laborbuch Xanthos pIdLaborbuch,IdLaborbuch,200,255 select laborbuch.Id, bereich.kuerzel as bereich, laborbuch.enummer as enummer, cast(cast((substring(convert(varchar,materialeingang.enummer),5,6)) as int)as varchar) + '/' + (substring(convert(varchar,materialeingang.enummer),3,2)) as enummerformatiert, laborbuch.nummer as o_nummer, lb2.nummer as b_nummer, l3.kuerzel f_kuerzel, l.kuerzel as o_kuerzel, l2.kuerzel as b_kuerzel, lb2.text as b_text, laborbuch.text as o_text, lb3.text as f_text, char(lb2.nummer+64) as b_Nummer_formatiert, laborbuch.Id OTLaborbuchNummer from laborbuch join laborbuch lb2 on lb2.id = laborbuch.idGehoertzu left join laborbuch lb3 on lb3.idgehoertzu = laborbuch.id join materialeingang on laborbuch.idmaterialeingang = materialeingang.id join zuweisung on materialeingang.idzuweisung = zuweisung.id join bereich on zuweisung.idbereich = bereich.id join laborbuchcode l on laborbuch.idlaborbuchcode = l.id join laborbuchcode l2 on lb2.idlaborbuchcode = l2.id left join laborbuchcode l3 on lb3.idlaborbuchcode = l3.id where Laborbuch.Geloescht = 0 AND Laborbuch.id in (2180029, 2180036, 2180033, 2180031, 2180318, 2180320, 2180323, 2180325, 2180045, 2180330, 2180332, 2180335, 2180337, 2180420, 2180422, 2180425, 2180427, 2180456, 2180458, 2180064, 2180067, 2180070, 2180073, 2180075, 2180079, 2180082, 2180085, 2180088, 2180094, 2180091, 2180089, 2180100, 2180103, 2180106, 2180109, 2180115, 2180609, 2180611, 2180110, 2180121, 2180124, 2180126, 2180130, 2180133, 2180135, 2180142, 2180139, 2180137, 2180151, 2180665, 2180667, 2180146, 2180157, 2180160); ,IdLaborbuch,IdLaborbuch,,System.Object,_x0039_33009,False,False,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent False 0,0.4,20.3,1.6 Transparent 0,1,2.35,0.6 Times New Roman,15.75,Bold,Point,False,0 0,5,0,0 Text1 {Laborbuch.enummerformatiert} Black Wysiwyg Expression Bottom Transparent 0,0.2,1.6,0.8 Times New Roman,10,Bold 37067df82ba84bf59567498f868fe19d 0,5,0,0 Text2 {Laborbuch.b_nummer}-{Laborbuch.o_nummer}{IIF(Laborbuch.f_kuerzel=="HE",""," " + Laborbuch.f_kuerzel)} {Laborbuch.b_text} Black Wysiwyg Expression True White 1.4,0.2,0.9,0.9 {Laborbuch.OTLaborbuchNummer} Arial,8,Bold,Pixel Black BarCode1 Laborbuch DataBand1 True ASC enummerformatiert ASC b_nummer ASC o_nummer 1a1dcd380e644b2891a69523d6e6bc46 0.2,0.5,0,0 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 2/26/2016 11:17:58 AM 7/9/2012 11:32:40 AM I:\Temp\FK\report.mrt 0f7fa6cc5cfa4c0384ea710950bf8ee7 Report Centimeters 2015.3.0 CSharp