ET_conn Integrated Security=True;Initial Catalog=TEST;Data Source=. ET_conn rptNeedleAssignments Ord_Num,System.String ID,System.Int32 MachineCode,System.String PlannedRunDate,System.DateTime PlannedShift,System.Int16 MachineSeq,System.Int32 WO_ID,System.Int64 WO_Suf,System.String HeadNumber,System.Int32 RunNumber,System.Int32 Prod_Num,System.String Op1_Thread,System.String Op2_Thread,System.String Op3_Thread,System.String Op4_Thread,System.String Op5_Thread,System.String Op6_Thread,System.String Op7_Thread,System.String Op8_Thread,System.String Op9_Thread,System.String Op10_Thread,System.String Op11_Thread,System.String Op12_Thread,System.String Op13_Thread,System.String Op14_Thread,System.String Op15_Thread,System.String Op16_Thread,System.String Op17_Thread,System.String Op18_Thread,System.String Op19_Thread,System.String Op20_Thread,System.String Op21_Thread,System.String Op22_Thread,System.String Op23_Thread,System.String Op24_Thread,System.String Op25_Thread,System.String MachineID,System.Int32 TimeStamp,System.Byte[] Company,System.String Course_Num,System.String AlphaCode,System.String OrdDisplay,System.String 30 rptNeedleAssignments ET_conn _x0040_BegRunDate,_x0022_2000-01-01_x0022_,4,0 _x0040_EndRunDate,_x0022_2020-01-01_x0022_,4,0 _x0040_Ord_Num,_x0022__x0022_,12,25 _x0040_WO_Suf,_x0022__x0022_,12,8 _x0040_MachineList,_x0020__x0022_M-01_x002C_M-02_x0022_,12,2000 execute rptNeedleAssignments @Ord_Num, @WO_Suf, @BegRunDate, @EndRunDate, @MachineList ConesReq ConesRequired,System.Int64 ThreadNum,System.String WO_ID,System.Int64 MachineCode,System.String 30 ConesReq ET_conn select * from ConesReq alias WO_ID name Link_WOID WO_ID ,vSortHeadsFirst,vSortHeadsFirst,System.String,false,False,False,True EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,10.22,0.4 Transparent 0.7,0,0.8,0.2 Arial,8 ccd7084367204e288613aaf120fd6778 0,0,0,0 Text3 {Today} Black Transparent 0.3,0,0.4,0.2 Arial,8 b67175fe9bc847aaa396c0ca11b016d5 0,0,0,0 Text4 Printed: Black Transparent 1.6,0,6.9,0.3 Arial,14,Bold 4a91a5a33ce1448daab46dec01683367 Center 0,0,0,0 Text5 Embroidery Needle Assignment Black Transparent 7.9,0,2.15,0.4 {rptNeedleAssignments.OrdDisplay} Arial,8,Bold,Pixel Black f80224cd252a42959818f8b8ff84704a Center BarCode1 PageHeaderBand1 Transparent 0,1,10.22,0.6 Transparent 0.3,0,0.7,0.2 Arial,8 ab1064bd0fdf40568a988d79bb3b8b8a 0,0,0,0 Text1 {PageNofM} Black Transparent 7.9,0,2.1,0.2 Arial,14,Bold 24eef3cc3cba43f38fd60a4df5829f62 0,0,0,0 Text9 {rptNeedleAssignments.OrdDisplay} Black Transparent 7.2,0,0.7,0.2 Arial,14,Bold 4048541d89204fd0a138d0f9ea98381c 0,0,0,0 Text6 WO #: Black {rptNeedleAssignments.WO_ID} GroupHeaderBand3 True True Bottom;Black;1;Solid;False;4;Black Transparent 0,2,10.22,1.2 Transparent 0.4,0,0.7,0.2 Arial,8 e91efbf4253e4b6884aae44d71c38da9 0,0,0,0 Text7 Planned: Black Transparent 3.2,0,0.8,0.2 Arial,8 e8ba321622b44c668fe7378836c4c60d 0,0,0,0 Text8 Actual: Black Transparent 0.8,0.3,0.6,0.2 Arial,8 e44c17b013c64131a6ffd3b19a0c8e10 0,0,0,0 Text10 Run Date: Black Transparent 1.5,0.3,0.9,0.2 Arial,8 56902facb2c347a9970eddfe806e83c7 0,0,0,0 Text14 {rptNeedleAssignments.PlannedRunDate} Black Transparent 0.8,0.6,0.6,0.2 Arial,8 7dfce6f7f04f49728ff0a0d5cbad7230 0,0,0,0 Text20 Machine: Black Transparent 1.5,0.6,0.5,0.2 Arial,8 0,0,0,0 Text21 {rptNeedleAssignments.MachineCode} Black Right;Black;1;Solid;False;4;Black Transparent 0,1,0.5,0.2 Arial,10,Bold 0,0,0,0 Text11 {IIF(vSortHeadsFirst.EndsWith("true", StringComparison.OrdinalIgnoreCase), "HD RN", "RN HD")} Black Left;Black;1;Solid;False;4;Black Transparent 8.9,1,1.3,0.2 Arial,10,Bold Center 0,0,0,0 Text13 PRODUCT Black Transparent 3.5,0.3,0.6,0.2 Arial,8 88b770c4874646d5849e92dd3ee8a5c8 Right 0,0,0,0 Text17 Run Date: Black Transparent 3.5,0.6,0.6,0.2 Arial,8 b8eec2e8c697491c8472f1a4e5391827 Right 0,0,0,0 Text19 Shift: Black Transparent 5.5,0.6,0.6,0.2 Arial,8 c615f0dc54274fa088bbb295e08b609b Right 0,0,0,0 Text23 Machine: Black Transparent 5.5,0.3,0.6,0.2 Arial,8 5dcbaec2bb0449dfbc39a04e016ad170 Right 0,0,0,0 Text24 Operator: Black Transparent 7.5,0.3,0.9,0.2 Arial,8 acb4ca07a17d41f087bc4c2bec206f96 Right 0,0,0,0 Text29 Time Started: Black Transparent 7.5,0.6,0.9,0.2 Arial,8 45fb186af09f43579641ea43310dbe35 Right 0,0,0,0 Text30 Time Completed: Black Transparent 4.7,1,0.6,0.2 Arial,10,Bold e1b64622733f49cf9b145ff515c2c3b1 Center 0,0,0,0 Text45 8 Black Transparent 5.3,1,0.6,0.2 Arial,10,Bold fe60a6632c8d436d89896ad8c818607b Center 0,0,0,0 Text46 9 Black Transparent 5.9,1,0.6,0.2 Arial,10,Bold e28c8e4db05240d4ae621870dcff8ff1 Center 0,0,0,0 Text47 10 Black Transparent 6.5,1,0.6,0.2 Arial,10,Bold 1111cb5578c546e6b6db9972e903dd45 Center 0,0,0,0 Text48 11 Black Transparent 7.1,1,0.6,0.2 Arial,10,Bold ae9720f401f447e6874510437030d701 Center 0,0,0,0 Text49 12 Black Transparent 7.7,1,0.6,0.2 Arial,10,Bold fcef714b382b4629b2a51a4229cc63ac Center 0,0,0,0 Text50 13 Black Transparent 8.3,1,0.6,0.2 Arial,10,Bold 976005d2504744849e0b205d3095e0b2 Center 0,0,0,0 Text51 14 Black Transparent 0.5,1,0.6,0.2 Arial,10,Bold 6bb0811421114e79bddb842d62f97b58 Center 0,0,0,0 Text58 1 Black Transparent 1.1,1,0.6,0.2 Arial,10,Bold 2642e2ac519d43adba7eb31d891a0afa Center 0,0,0,0 Text59 2 Black Transparent 1.7,1,0.6,0.2 Arial,10,Bold 2788807385314576aa4d0a5248e6486e Center 0,0,0,0 Text60 3 Black Transparent 2.3,1,0.6,0.2 Arial,10,Bold 8da6990d311f4d9e8467b7d14456af6f Center 0,0,0,0 Text61 4 Black Transparent 2.9,1,0.6,0.2 Arial,10,Bold 374e904f098141d99f4ba318d5a0b351 Center 0,0,0,0 Text62 5 Black Transparent 3.5,1,0.6,0.2 Arial,10,Bold c427dc82c5ea47728ce712b242daceb8 Center 0,0,0,0 Text63 6 Black Transparent 4.1,1,0.6,0.2 Arial,10,Bold c4bea55291a446828a9a5d1be0aad794 Center 0,0,0,0 Text64 7 Black 0.5,0.2,0,0 StartPointPrimitive1 8c8f3f13a040417d9b2682714244fc31 2.8,0.9,0,0 EndPointPrimitive1 8c8f3f13a040417d9b2682714244fc31 3.3,0.2,0,0 StartPointPrimitive2 7df039de615e4a50812404d058e6b3da 10.1,0.9,0,0 EndPointPrimitive2 7df039de615e4a50812404d058e6b3da 4.2,0.5,1.1,0.01 Black Black HorizontalLinePrimitive1 Black 4.2,0.8,1.1,0.01 Black Black 49bc05103d7d42cb97bd1094103dfa1a HorizontalLinePrimitive2 Black 6.2,0.5,1.1,0.01 Black Black cfc1d6829daa454ba49bfe37dced43fd HorizontalLinePrimitive3 Black 6.2,0.8,1.1,0.01 Black Black 99f560a16eaf4f22b1011657ded0a188 HorizontalLinePrimitive4 Black 0.5,1,0,0 StartPointPrimitive5 c5220b6af7784926bb1169b061abc584 8.5,0.5,1.1,0.01 Black Black 2622cff011444552860151bbaf725524 HorizontalLinePrimitive5 Black 8.5,0.8,1.1,0.01 Black Black c0260a2ad809410e899e1334ce619314 HorizontalLinePrimitive6 Black 8.9,1.2,0,0 EndPointPrimitive5 c5220b6af7784926bb1169b061abc584 {rptNeedleAssignments.WO_ID} GroupHeaderBand1 True True Right, Bottom;Black;1;Solid;False;4;Black Transparent 0,3.6,10.22,0.2 Right;Black;1;Solid;False;4;Black Transparent 0,0,0.2,0.2 Arial,8 Right 0,0,0,0 Text16 {IIF(vSortHeadsFirst.EndsWith("true", StringComparison.OrdinalIgnoreCase), rptNeedleAssignments.HeadNumber, rptNeedleAssignments.RunNumber)} Black Expression Right;Black;1;Solid;False;4;Black Transparent 0.25,0,0.25,0.2 Arial,8 Right 0,0,0,0 Text18 {IIF(vSortHeadsFirst.EndsWith("true", StringComparison.OrdinalIgnoreCase), rptNeedleAssignments.RunNumber, rptNeedleAssignments.HeadNumber)} Black Expression All;Black;1;Solid;False;4;Black Transparent 0.5,0,0.6,0.2 _x007B_rptNeedleAssignments.Op1_Thread_x0020__x0021__x003D__x0020_Previous_x0020__x0028_rptNeedleAssignments_x002C__x0022_Op1_Thread_x0022__x0029_.ToString_x0028__x0029__x007D_,Red,LightGray,Arial_x002C_8,True,False,,,None Arial,8 Center 0,0,0,0 Text15 {rptNeedleAssignments.Op1_Thread} Black Expression All;Black;1;Solid;False;4;Black Transparent 1.6,0,0.6,0.2 Arial,8 e976d1b64f0e4a5bba175733bdd38126 Center 0,0,0,0 Text12 {rptNeedleAssignments.Op1_Thread} Black Expression All;Black;1;Solid;False;4;Black Transparent 2.2,0,0.6,0.2 Arial,8 e051b3578210411b8364083aeaf18406 Center 0,0,0,0 Text22 {Previous(rptNeedleAssignments,"Op1_Thread")} Black Expression rptNeedleAssignments DataBand1 True ASC HeadNumber ASC RunNumber Transparent 0,4.2,10.22,2 Transparent 0.9,0.1,0.6,0.2 Arial,10,Bold 0,0,0,0 Text52 {IIF(Count(DataBand1)>0,Max(DataBand1,rptNeedleAssignments.HeadNumber),0)} Black Transparent 0.2,0.1,0.7,0.2 Arial,10,Bold Right 0,0,0,0 Text53 Heads: Black Transparent 2.8,0.1,0.6,0.2 Arial,10,Bold 128858e4a89549ab8f7bd61035316088 0,0,0,0 Text54 {IIF(Count(DataBand1)>0,Max(DataBand1,rptNeedleAssignments.RunNumber),0)} Black Transparent 2.1,0.1,0.7,0.2 Arial,10,Bold d83cb1732bff42119432d24d40f2c2a9 Right 0,0,0,0 Text55 Runs: Black Transparent 4.8,0.1,0.6,0.2 Arial,10,Bold ef86b667e653429797bbaf123ec927d4 0,0,0,0 Text56 {Count(DataBand1)} Black Transparent 4.1,0.1,0.7,0.2 Arial,10,Bold 17119dbdc05b4feeac65a5eca832a5c9 Right 0,0,0,0 Text57 Pieces: Black GroupFooterBand1 0.5,2.2,2.3,0.7 Black 8c8f3f13a040417d9b2682714244fc31 RectanglePrimitive1 3.3,2.2,6.8,0.7 Black 7df039de615e4a50812404d058e6b3da RectanglePrimitive2 0.5,3,8.4,0.2 Black c5220b6af7784926bb1169b061abc584 RectanglePrimitive3 fff8afc2766d4e04a626de937642db35 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter 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/24/2015 9:22:09 AM 6/10/2011 12:17:05 PM E:\NA12wOneFilter2.mrt 490a87e571ad4809ad03b93269e060b7 Report Inches 2011.2.1100 CSharp