{ "ReportVersion": "2019.3.1.0", "ReportGuid": "7918d94e73f74872a1071ab4990d8384", "ReportName": "Report", "ReportAlias": "Report", "ReportCreated": "/Date(864000000+0530)/", "ReportChanged": "/Date(1614779291935+0530)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "PreviewSettings": 268435455, "Script": "using System;\r\nusing System.Drawing;\r\nusing System.Windows.Forms;\r\nusing System.Data;\r\nusing Stimulsoft.Controls;\r\nusing Stimulsoft.Base.Drawing;\r\nusing Stimulsoft.Report;\r\nusing Stimulsoft.Report.Dialogs;\r\nusing Stimulsoft.Report.Components;\r\n\r\nnamespace Reports\r\n{\r\n public class Report : Stimulsoft.Report.StiReport\r\n {\r\n public Report() {\r\n this.InitializeComponent();\r\n }\r\n\r\n #region StiReport Designer generated code - do not modify\r\n\t\t#endregion StiReport Designer generated code - do not modify\r\n }\r\n}\r\n", "ReferencedAssemblies": { "0": "System.Dll", "1": "System.Drawing.Dll", "2": "System.Windows.Forms.Dll", "3": "System.Data.Dll", "4": "System.Xml.Dll", "5": "Stimulsoft.Controls.Dll", "6": "Stimulsoft.Base.Dll", "7": "Stimulsoft.Report.Dll" }, "Dictionary": { "Variables": { "0": { "Value": "LHSS1004", "Name": "Orno", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "Order No", "Type": "System.String", "RequestFromUser": true }, "1": { "Value": "Labels", "Name": "Type", "DialogInfo": { "DateTimeType": "DateAndTime", "Keys": { "0": "Labels", "1": "Works Order" }, "Values": { "0": "Labels", "1": "Works Order" } }, "Alias": "Select", "Type": "System.String", "RequestFromUser": true } }, "DataSources": { "0": { "Ident": "StiMySqlSource", "Name": "DataSource1", "Alias": "DataSource1", "Key": "ab0ef0b36f404c0bb69d2e36df5ca18f", "Columns": { "0": { "Name": "BorR", "Index": -1, "NameInSource": "BorR", "Alias": "BorR", "Type": "System.String" }, "1": { "Name": "BottomChannelColorQtySubComp", "Index": -1, "NameInSource": "BottomChannelColorQtySubComp", "Alias": "BottomChannelColorQtySubComp", "Type": "System.String" }, "2": { "Name": "BottomChannelColorSubComp", "Index": -1, "NameInSource": "BottomChannelColorSubComp", "Alias": "BottomChannelColorSubComp", "Type": "System.String" }, "3": { "Name": "Brackets", "Index": -1, "NameInSource": "Brackets", "Alias": "Brackets", "Type": "System.String" }, "4": { "Name": "Braid", "Index": -1, "NameInSource": "Braid", "Alias": "Braid", "Type": "System.String" }, "5": { "Name": "BraidColoursEdit", "Index": -1, "NameInSource": "BraidColoursEdit", "Alias": "BraidColoursEdit", "Type": "System.String" }, "6": { "Name": "BraidsExtras", "Index": -1, "NameInSource": "BraidsExtras", "Alias": "BraidsExtras", "Type": "System.String" }, "7": { "Name": "ChainAllowance", "Index": -1, "NameInSource": "ChainAllowance", "Alias": "ChainAllowance", "Type": "System.String" }, "8": { "Name": "ChainAllowance", "Index": -1, "NameInSource": "ChainAllowance", "Alias": "ChainAllowance", "Type": "System.String" }, "9": { "Name": "ChainAllowance", "Index": -1, "NameInSource": "ChainAllowance", "Alias": "ChainAllowance", "Type": "System.String" }, "10": { "Name": "ChainAllowance", "Index": -1, "NameInSource": "ChainAllowance", "Alias": "ChainAllowance", "Type": "System.String" }, "11": { "Name": "ChainAllowance", "Index": -1, "NameInSource": "ChainAllowance", "Alias": "ChainAllowance", "Type": "System.String" }, "12": { "Name": "ChainAllowance", "Index": -1, "NameInSource": "ChainAllowance", "Alias": "ChainAllowance", "Type": "System.Decimal" }, "13": { "Name": "ChainColour", "Index": -1, "NameInSource": "ChainColour", "Alias": "ChainColour", "Type": "System.String" }, "14": { "Name": "ChainLength", "Index": -1, "NameInSource": "ChainLength", "Alias": "ChainLength", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(System.Convert.ToDouble(DataSource1.Childallowance)>0,(System.Convert.ToDouble(DataSource1.Childallowance) * 2),(DataSource1.drope * 2) - \r\nSystem.Convert.ToDouble(DataSource1.ChainAllowance))" }, "15": { "Name": "ChainLengthFormula", "Index": -1, "NameInSource": "ChainLengthFormula", "Alias": "ChainLengthFormula", "Type": "System.String" }, "16": { "Name": "ChainLengthinch", "Index": -1, "NameInSource": "ChainLengthinch", "Alias": "ChainLengthinch", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".0\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"000\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".1\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"125\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".2\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"250\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".3\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"375\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".4\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".5\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".6\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"625\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".7\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"750\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".8\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1)+\"875\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") ),2)==\".9\",System.Convert.ToInt32(Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))).IndexOf(\".\") +1))+1+\".000\",\r\nRight(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ChainLength/25.4,3)).IndexOf(\".\") )+\".000\"))))))))))" }, "17": { "Name": "Chainsystem", "Index": -1, "NameInSource": "Chainsystem", "Alias": "Chainsystem", "Type": "System.String" }, "18": { "Name": "Childallowance", "Index": -1, "NameInSource": "Childallowance", "Alias": "Childallowance", "Type": "System.String" }, "19": { "Name": "ClothDrop", "Index": -1, "NameInSource": "ClothDrop", "Alias": "ClothDrop", "Type": "System.Int32", "Ident": "Calc", "Expression": "(DataSource1.drope + System.Convert.ToInt32(DataSource1.DropAllowance))" }, "20": { "Name": "ClothDropinch", "Index": -1, "NameInSource": "ClothDropinch", "Alias": "ClothDropinch", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".0\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"000\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".1\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"125\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".2\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"250\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".3\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"375\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".4\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".5\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".6\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"625\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".7\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"750\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".8\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1)+\"875\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") ),2)==\".9\",System.Convert.ToInt32(Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))).IndexOf(\".\") +1))+1+\".000\",\r\nRight(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothDrop/25.4,3)).IndexOf(\".\") )+\".000\"))))))))))" }, "21": { "Name": "ClothWidth", "Index": -1, "NameInSource": "ClothWidth", "Alias": "ClothWidth", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(DataSource1.BorR==\"Recess\",(DataSource1.width - System.Convert.ToDouble(DataSource1.SystemAllowance) - System.Convert.ToDouble(DataSource1.RecessAllowance)),IIF(DataSource1.BorR==\"Cloth Size\" || DataSource1.BorR==\"Material\", DataSource1.width,DataSource1.width - System.Convert.ToDouble(DataSource1.SystemAllowance)))" }, "22": { "Name": "ClothWidthinch", "Index": -1, "NameInSource": "ClothWidthinch", "Alias": "ClothWidthinch", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".0\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"000\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".1\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"125\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".2\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"250\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".3\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"375\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".4\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".5\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".6\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"625\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".7\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"750\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".8\",Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1)+\"875\",\r\nIIF(Left(Right(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") ),2)==\".9\",System.Convert.ToInt32(Left(Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))),Format(\"{0:0}\", Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))).IndexOf(\".\") +1))+1+\".000\",\r\nRight(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)),Length(Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3))) - Format(\"{0:0}\", Round(DataSource1.ClothWidth/25.4,3)).IndexOf(\".\") )+\".000\"))))))))))" }, "23": { "Name": "ClothdropFormula", "Index": -1, "NameInSource": "ClothdropFormula", "Alias": "ClothdropFormula", "Type": "System.String" }, "24": { "Name": "ClothwidthFormula", "Index": -1, "NameInSource": "ClothwidthFormula", "Alias": "ClothwidthFormula", "Type": "System.String" }, "25": { "Name": "Colour", "Index": -1, "NameInSource": "Colour", "Alias": "Colour", "Type": "System.String" }, "26": { "Name": "Colourtext", "Index": -1, "NameInSource": "Colourtext", "Alias": "Colourtext", "Type": "System.String" }, "27": { "Name": "Components", "Index": -1, "NameInSource": "Components", "Alias": "Components", "Type": "System.String" }, "28": { "Name": "ControlSide", "Index": -1, "NameInSource": "ControlSide", "Alias": "ControlSide", "Type": "System.String" }, "29": { "Name": "Controls", "Index": -1, "NameInSource": "Controls", "Alias": "Controls", "Type": "System.String" }, "30": { "Name": "CordLengthFormula", "Index": -1, "NameInSource": "CordLengthFormula", "Alias": "CordLengthFormula", "Type": "System.String" }, "31": { "Name": "DelAddress", "Index": -1, "NameInSource": "DelAddress", "Alias": "DelAddress", "Type": "System.String" }, "32": { "Name": "DelAddress1", "Index": -1, "NameInSource": "DelAddress1", "Alias": "DelAddress1", "Type": "System.String" }, "33": { "Name": "DelAddress2", "Index": -1, "NameInSource": "DelAddress2", "Alias": "DelAddress2", "Type": "System.String" }, "34": { "Name": "DelCity", "Index": -1, "NameInSource": "DelCity", "Alias": "DelCity", "Type": "System.String" }, "35": { "Name": "DelCounty", "Index": -1, "NameInSource": "DelCounty", "Alias": "DelCounty", "Type": "System.String" }, "36": { "Name": "Delcompany", "Index": -1, "NameInSource": "Delcompany", "Alias": "Delcompany", "Type": "System.String" }, "37": { "Name": "Delcountry", "Index": -1, "NameInSource": "Delcountry", "Alias": "Delcountry", "Type": "System.String" }, "38": { "Name": "Delmobile", "Index": -1, "NameInSource": "Delmobile", "Alias": "Delmobile", "Type": "System.String" }, "39": { "Name": "Delphone", "Index": -1, "NameInSource": "Delphone", "Alias": "Delphone", "Type": "System.String" }, "40": { "Name": "Delpostcode", "Index": -1, "NameInSource": "Delpostcode", "Alias": "Delpostcode", "Type": "System.String" }, "41": { "Name": "DropAllowance", "Index": -1, "NameInSource": "DropAllowance", "Alias": "DropAllowance", "Type": "System.String" }, "42": { "Name": "DropAllowance", "Index": -1, "NameInSource": "DropAllowance", "Alias": "DropAllowance", "Type": "System.String" }, "43": { "Name": "DropAllowance", "Index": -1, "NameInSource": "DropAllowance", "Alias": "DropAllowance", "Type": "System.String" }, "44": { "Name": "DropAllowance", "Index": -1, "NameInSource": "DropAllowance", "Alias": "DropAllowance", "Type": "System.String" }, "45": { "Name": "DropAllowance", "Index": -1, "NameInSource": "DropAllowance", "Alias": "DropAllowance", "Type": "System.String" }, "46": { "Name": "DropAllowance", "Index": -1, "NameInSource": "DropAllowance", "Alias": "DropAllowance", "Type": "System.Decimal" }, "47": { "Name": "ExtrasNew", "Index": -1, "NameInSource": "ExtrasNew", "Alias": "ExtrasNew", "Type": "System.String" }, "48": { "Name": "ExtrasNewBottomChannel", "Index": -1, "NameInSource": "ExtrasNewBottomChannel", "Alias": "ExtrasNewBottomChannel", "Type": "System.String" }, "49": { "Name": "ExtrasNewFreeFormFascia", "Index": -1, "NameInSource": "ExtrasNewFreeFormFascia", "Alias": "ExtrasNewFreeFormFascia", "Type": "System.String" }, "50": { "Name": "ExtrasNewHanger", "Index": -1, "NameInSource": "ExtrasNewHanger", "Alias": "ExtrasNewHanger", "Type": "System.String" }, "51": { "Name": "ExtrasNewInchFlap", "Index": -1, "NameInSource": "ExtrasNewInchFlap", "Alias": "ExtrasNewInchFlap", "Type": "System.String" }, "52": { "Name": "ExtrasNewSideChannel", "Index": -1, "NameInSource": "ExtrasNewSideChannel", "Alias": "ExtrasNewSideChannel", "Type": "System.String" }, "53": { "Name": "FGroup", "Index": -1, "NameInSource": "FGroup", "Alias": "FGroup", "Type": "System.String" }, "54": { "Name": "FabQty", "Index": -1, "NameInSource": "FabQty", "Alias": "FabQty", "Type": "System.Int32", "Ident": "Calc", "Expression": "Round((DataSource1.drope + System.Convert.ToInt32(DataSource1.DropAllowance)) / 1000,2)" }, "55": { "Name": "Fabric", "Index": -1, "NameInSource": "Fabric", "Alias": "Fabric", "Type": "System.String" }, "56": { "Name": "FabricAmountFormula", "Index": -1, "NameInSource": "FabricAmountFormula", "Alias": "FabricAmountFormula", "Type": "System.String" }, "57": { "Name": "FabricQtyFormula", "Index": -1, "NameInSource": "FabricQtyFormula", "Alias": "FabricQtyFormula", "Type": "System.String" }, "58": { "Name": "FabricSizeFormula", "Index": -1, "NameInSource": "FabricSizeFormula", "Alias": "FabricSizeFormula", "Type": "System.String" }, "59": { "Name": "FurtherInstructions", "Index": -1, "NameInSource": "FurtherInstructions", "Alias": "FurtherInstructions", "Type": "System.String" }, "60": { "Name": "HeadrailColour", "Index": -1, "NameInSource": "HeadrailColour", "Alias": "HeadrailColour", "Type": "System.String" }, "61": { "Name": "HeadrailType", "Index": -1, "NameInSource": "HeadrailType", "Alias": "HeadrailType", "Type": "System.String" }, "62": { "Name": "Locations", "Index": -1, "NameInSource": "Locations", "Alias": "Locations", "Type": "System.String" }, "63": { "Name": "MotorizedExtras", "Index": -1, "NameInSource": "MotorizedExtras", "Alias": "MotorizedExtras", "Type": "System.String" }, "64": { "Name": "MountType", "Index": -1, "NameInSource": "MountType", "Alias": "MountType", "Type": "System.String" }, "65": { "Name": "MountTypeExtras", "Index": -1, "NameInSource": "MountTypeExtras", "Alias": "MountTypeExtras", "Type": "System.String" }, "66": { "Name": "Mrs", "Index": -1, "NameInSource": "Mrs", "Alias": "Mrs", "Type": "System.String" }, "67": { "Name": "PoleType", "Index": -1, "NameInSource": "PoleType", "Alias": "PoleType", "Type": "System.String" }, "68": { "Name": "PolesFinialsColoursEdit", "Index": -1, "NameInSource": "PolesFinialsColoursEdit", "Alias": "PolesFinialsColoursEdit", "Type": "System.String" }, "69": { "Name": "Ptype", "Index": -1, "NameInSource": "Ptype", "Alias": "Ptype", "Type": "System.String" }, "70": { "Name": "PullCord", "Index": -1, "NameInSource": "PullCord", "Alias": "PullCord", "Type": "System.String" }, "71": { "Name": "PullsExtrasEdit", "Index": -1, "NameInSource": "PullsExtrasEdit", "Alias": "PullsExtrasEdit", "Type": "System.String" }, "72": { "Name": "PullsPolesExtras", "Index": -1, "NameInSource": "PullsPolesExtras", "Alias": "PullsPolesExtras", "Type": "System.String" }, "73": { "Name": "RailColour", "Index": -1, "NameInSource": "RailColour", "Alias": "RailColour", "Type": "System.String" }, "74": { "Name": "RecessAllowance", "Index": -1, "NameInSource": "RecessAllowance", "Alias": "RecessAllowance", "Type": "System.String" }, "75": { "Name": "RecessAllowance", "Index": -1, "NameInSource": "RecessAllowance", "Alias": "RecessAllowance", "Type": "System.String" }, "76": { "Name": "RecessAllowance", "Index": -1, "NameInSource": "RecessAllowance", "Alias": "RecessAllowance", "Type": "System.String" }, "77": { "Name": "RecessAllowance", "Index": -1, "NameInSource": "RecessAllowance", "Alias": "RecessAllowance", "Type": "System.String" }, "78": { "Name": "RecessAllowance", "Index": -1, "NameInSource": "RecessAllowance", "Alias": "RecessAllowance", "Type": "System.String" }, "79": { "Name": "RecessAllowance", "Index": -1, "NameInSource": "RecessAllowance", "Alias": "RecessAllowance", "Type": "System.Decimal" }, "80": { "Name": "Roll", "Index": -1, "NameInSource": "Roll", "Alias": "Roll", "Type": "System.String" }, "81": { "Name": "SDrop", "Index": -1, "NameInSource": "SDrop", "Alias": "SDrop", "Type": "System.Int32" }, "82": { "Name": "SDrop", "Index": -1, "NameInSource": "SDrop", "Alias": "SDrop", "Type": "System.Int32" }, "83": { "Name": "SDrop", "Index": -1, "NameInSource": "SDrop", "Alias": "SDrop", "Type": "System.String" }, "84": { "Name": "SWidth", "Index": -1, "NameInSource": "SWidth", "Alias": "SWidth", "Type": "System.Int32" }, "85": { "Name": "SWidth", "Index": -1, "NameInSource": "SWidth", "Alias": "SWidth", "Type": "System.Int32" }, "86": { "Name": "SWidth", "Index": -1, "NameInSource": "SWidth", "Alias": "SWidth", "Type": "System.String" }, "87": { "Name": "ShapeScallopExtras", "Index": -1, "NameInSource": "ShapeScallopExtras", "Alias": "ShapeScallopExtras", "Type": "System.String" }, "88": { "Name": "ShapesFinishes", "Index": -1, "NameInSource": "ShapesFinishes", "Alias": "ShapesFinishes", "Type": "System.String" }, "89": { "Name": "SideChannelColorQtySubComp", "Index": -1, "NameInSource": "SideChannelColorQtySubComp", "Alias": "SideChannelColorQtySubComp", "Type": "System.String" }, "90": { "Name": "SideChannelColorSubComp", "Index": -1, "NameInSource": "SideChannelColorSubComp", "Alias": "SideChannelColorSubComp", "Type": "System.String" }, "91": { "Name": "SideChannelSizeSubComp", "Index": -1, "NameInSource": "SideChannelSizeSubComp", "Alias": "SideChannelSizeSubComp", "Type": "System.String" }, "92": { "Name": "SizeType", "Index": -1, "NameInSource": "SizeType", "Alias": "SizeType", "Type": "System.String" }, "93": { "Name": "SubPoleColour", "Index": -1, "NameInSource": "SubPoleColour", "Alias": "SubPoleColour", "Type": "System.String" }, "94": { "Name": "SystemAllowance", "Index": -1, "NameInSource": "SystemAllowance", "Alias": "SystemAllowance", "Type": "System.String" }, "95": { "Name": "SystemAllowance", "Index": -1, "NameInSource": "SystemAllowance", "Alias": "SystemAllowance", "Type": "System.String" }, "96": { "Name": "SystemAllowance", "Index": -1, "NameInSource": "SystemAllowance", "Alias": "SystemAllowance", "Type": "System.String" }, "97": { "Name": "SystemAllowance", "Index": -1, "NameInSource": "SystemAllowance", "Alias": "SystemAllowance", "Type": "System.String" }, "98": { "Name": "SystemAllowance", "Index": -1, "NameInSource": "SystemAllowance", "Alias": "SystemAllowance", "Type": "System.String" }, "99": { "Name": "SystemAllowance", "Index": -1, "NameInSource": "SystemAllowance", "Alias": "SystemAllowance", "Type": "System.Decimal" }, "100": { "Name": "SystemType", "Index": -1, "NameInSource": "SystemType", "Alias": "SystemType", "Type": "System.String" }, "101": { "Name": "SystemTypeExtrasNew", "Index": -1, "NameInSource": "SystemTypeExtrasNew", "Alias": "SystemTypeExtrasNew", "Type": "System.String" }, "102": { "Name": "accref", "Index": -1, "NameInSource": "accref", "Alias": "accref", "Type": "System.String" }, "103": { "Name": "address", "Index": -1, "NameInSource": "address", "Alias": "address", "Type": "System.String" }, "104": { "Name": "address1", "Index": -1, "NameInSource": "address1", "Alias": "address1", "Type": "System.String" }, "105": { "Name": "altphone", "Index": -1, "NameInSource": "altphone", "Alias": "altphone", "Type": "System.String" }, "106": { "Name": "city", "Index": -1, "NameInSource": "city", "Alias": "city", "Type": "System.String" }, "107": { "Name": "comment", "Index": -1, "NameInSource": "comment", "Alias": "comment", "Type": "System.String" }, "108": { "Name": "company", "Index": -1, "NameInSource": "company", "Alias": "company", "Type": "System.String" }, "109": { "Name": "companyName", "Index": -1, "NameInSource": "companyName", "Alias": "companyName", "Type": "System.String" }, "110": { "Name": "county", "Index": -1, "NameInSource": "county", "Alias": "county", "Type": "System.String" }, "111": { "Name": "createddate", "Index": -1, "NameInSource": "createddate", "Alias": "createddate", "Type": "System.DateTime" }, "112": { "Name": "custref", "Index": -1, "NameInSource": "custref", "Alias": "custref", "Type": "System.String" }, "113": { "Name": "custtype", "Index": -1, "NameInSource": "custtype", "Alias": "custtype", "Type": "System.String" }, "114": { "Name": "daterequired", "Index": -1, "NameInSource": "daterequired", "Alias": "daterequired", "Type": "System.DateTime" }, "115": { "Name": "default_unit_for_worksheet", "Index": -1, "NameInSource": "default_unit_for_worksheet", "Alias": "default_unit_for_worksheet", "Type": "System.String" }, "116": { "Name": "dropRecess", "Index": -1, "NameInSource": "dropRecess", "Alias": "dropRecess", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(DataSource1.BorR==\"Recess\", DataSource1.drope - System.Convert.ToDouble(DataSource1.RecessAllowance),DataSource1.drope)" }, "117": { "Name": "drope", "Index": -1, "NameInSource": "drope", "Alias": "drope", "Type": "System.Decimal" }, "118": { "Name": "drope", "Index": -1, "NameInSource": "drope", "Alias": "drope", "Type": "System.Decimal" }, "119": { "Name": "dropeinch", "Index": -1, "NameInSource": "dropeinch", "Alias": "dropeinch", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(DataSource1.widthmeasuretype==\"inch\",DataSource1.SDrop,\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".0\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"000\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".1\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"125\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".2\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"250\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".3\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"375\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".4\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".5\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".6\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"625\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".7\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"750\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".8\",Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\") +1)+\"875\",\r\nIIF(Left(Right(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") ),2)==\".9\",System.Convert.ToInt32(Left(Format(\"{0:0}\", DataSource1.SDrop),Format(\"{0:0}\", DataSource1.SDrop).IndexOf(\".\")+1))+1+\".000\",\r\nRight(DataSource1.SDrop,Length(DataSource1.SDrop) - DataSource1.SDrop.IndexOf(\".\") )+\".000\")))))))))))" }, "120": { "Name": "dropfraction", "Index": -1, "NameInSource": "dropfraction", "Alias": "dropfraction", "Type": "System.String" }, "121": { "Name": "firstname", "Index": -1, "NameInSource": "firstname", "Alias": "firstname", "Type": "System.String" }, "122": { "Name": "invoicedate", "Index": -1, "NameInSource": "invoicedate", "Alias": "invoicedate", "Type": "System.DateTime" }, "123": { "Name": "invoiceno", "Index": -1, "NameInSource": "invoiceno", "Alias": "invoiceno", "Type": "System.String" }, "124": { "Name": "invoiceno", "Index": -1, "NameInSource": "invoiceno", "Alias": "invoiceno", "Type": "System.String" }, "125": { "Name": "invoiceno", "Index": -1, "NameInSource": "invoiceno", "Alias": "invoiceno", "Type": "System.String" }, "126": { "Name": "invoiceno", "Index": -1, "NameInSource": "invoiceno", "Alias": "invoiceno", "Type": "System.String" }, "127": { "Name": "invoiceno", "Index": -1, "NameInSource": "invoiceno", "Alias": "invoiceno", "Type": "System.Int32" }, "128": { "Name": "lineitem_id", "Index": -1, "NameInSource": "lineitem_id", "Alias": "lineitem_id", "Type": "System.Int32" }, "129": { "Name": "newcolourlisttext", "Index": -1, "NameInSource": "newcolourlisttext", "Alias": "newcolourlisttext", "Type": "System.String" }, "130": { "Name": "orderdate", "Index": -1, "NameInSource": "orderdate", "Alias": "orderdate", "Type": "System.DateTime" }, "131": { "Name": "organizationname", "Index": -1, "NameInSource": "organizationname", "Alias": "organizationname", "Type": "System.String" }, "132": { "Name": "phone", "Index": -1, "NameInSource": "phone", "Alias": "phone", "Type": "System.String" }, "133": { "Name": "postcode", "Index": -1, "NameInSource": "postcode", "Alias": "postcode", "Type": "System.String" }, "134": { "Name": "productname", "Index": -1, "NameInSource": "productname", "Alias": "productname", "Type": "System.String" }, "135": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.Int32" }, "136": { "Name": "salesorder_no", "Index": -1, "NameInSource": "salesorder_no", "Alias": "salesorder_no", "Type": "System.String" }, "137": { "Name": "salesorderid", "Index": -1, "NameInSource": "salesorderid", "Alias": "salesorderid", "Type": "System.Int32" }, "138": { "Name": "surname", "Index": -1, "NameInSource": "surname", "Alias": "surname", "Type": "System.String" }, "139": { "Name": "title", "Index": -1, "NameInSource": "title", "Alias": "title", "Type": "System.String" }, "140": { "Name": "useworksheetaddress", "Index": -1, "NameInSource": "useworksheetaddress", "Alias": "useworksheetaddress", "Type": "System.Int32" }, "141": { "Name": "width", "Index": -1, "NameInSource": "width", "Alias": "width", "Type": "System.Decimal" }, "142": { "Name": "width", "Index": -1, "NameInSource": "width", "Alias": "width", "Type": "System.Decimal" }, "143": { "Name": "widthRecess", "Index": -1, "NameInSource": "widthRecess", "Alias": "widthRecess", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(DataSource1.BorR==\"Recess\", DataSource1.width - System.Convert.ToDouble(DataSource1.RecessAllowance),DataSource1.width)" }, "144": { "Name": "widthfraction", "Index": -1, "NameInSource": "widthfraction", "Alias": "widthfraction", "Type": "System.String" }, "145": { "Name": "widthinch", "Index": -1, "NameInSource": "widthinch", "Alias": "widthinch", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(DataSource1.widthmeasuretype==\"inch\",DataSource1.SWidth,\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".0\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"000\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".1\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"125\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".2\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"250\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".3\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"375\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".4\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".5\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"500\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".6\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"625\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".7\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"750\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".8\",Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1)+\"875\",\r\nIIF(Left(Right(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") ),2)==\".9\",System.Convert.ToInt32(Left(Format(\"{0:0}\", DataSource1.SWidth),Format(\"{0:0}\", DataSource1.SWidth).IndexOf(\".\") +1))+1+\".000\",\r\nRight(DataSource1.SWidth,Length(DataSource1.SWidth) - DataSource1.SWidth.IndexOf(\".\") )+\".000\")))))))))))" }, "146": { "Name": "widthmeasuretype", "Index": -1, "NameInSource": "widthmeasuretype", "Alias": "widthmeasuretype", "Type": "System.String" } }, "NameInSource": "my", "SqlCommand": "SELECT\r\n\tvtiger_salesorder.salesorder_no,\r\n\tvtiger_inventoryproductrel.widthmeasuretype,\r\n\tvtiger_salesorder.company,\r\n\tvtiger_salesorder.custref,\r\n\tvtiger_salesorder.custtype,\r\n\tvtiger_salesorder.accref,\r\n\tvtiger_salesorder.salesorderid,\r\n\tvtiger_salesorder.invoiceno,\r\n\tvtiger_salesorder.orderdate,\r\n\tvtiger_salesorder.invoicedate,\r\n\tvtiger_salesorder.createddate,\r\n\tvtiger_salesorder.daterequired,\r\n\tvtiger_salesorder.title,\r\n\tvtiger_salesorder.address,\r\n\tvtiger_salesorder.address1,\r\n\tvtiger_salesorder.city,\r\n\tvtiger_salesorder.county,\r\n\tvtiger_salesorder.postcode,\r\n\tvtiger_salesorder.phone,\r\n\tvtiger_salesorder.altphone,\r\n\tvtiger_products.productname,\r\n\tvtiger_inventoryproductrel.quantity,\r\n\tvtiger_inventoryproductrel.producttype As FGroup,\r\n\tvtiger_inventoryproductrel.comment,\r\n\tvtiger_inventoryproductrel.lineitem_id,\r\n\tvtiger_organizationdetails.organizationname,\r\n\tsoftMax_ApplicationSetup.default_unit_for_worksheet,\r\n\tsoftMax_AlternateDeliveryAddress.comapnyname As Delcompany,\r\n\tsoftMax_AlternateDeliveryAddress.mobile As Delmobile,\r\n\tsoftMax_AlternateDeliveryAddress.addName As DelAddress,\r\n\tsoftMax_AlternateDeliveryAddress.address1 As DelAddress1,\r\n\tsoftMax_AlternateDeliveryAddress.address2 As DelAddress2,\r\n\tsoftMax_AlternateDeliveryAddress.city As DelCity,\r\n\tsoftMax_AlternateDeliveryAddress.county As DelCounty,\r\n\tsoftMax_AlternateDeliveryAddress.postcode As Delpostcode,\r\n\tsoftMax_AlternateDeliveryAddress.country As Delcountry,\r\n\tsoftMax_AlternateDeliveryAddress.phone As Delphone,\r\n\tvtiger_salesorder.useworksheetaddress,\r\n\r\n\t(SELECT CASE WHEN (vtiger_salesorder.firstname=\".\" or vtiger_salesorder.firstname=\"-\" or vtiger_salesorder.firstname=\"\") THEN \"\" ELSE vtiger_salesorder.firstname END) As firstname,\r\n(SELECT CASE WHEN (vtiger_salesorder.surname=\".\" or vtiger_salesorder.surname=\"-\" or vtiger_salesorder.surname=\"\") THEN \"\" ELSE vtiger_salesorder.surname END) As surname,\r\n\r\n(SELECT CASE WHEN (vtiger_salesorder.title=\".\" or vtiger_salesorder.title=\"-\") THEN \"\" ELSE CONCAT (vtiger_salesorder.title, \" \") END) As Mrs,\r\n\r\n(SELECT CASE WHEN vtiger_salesorder.company<>'' THEN vtiger_salesorder.company ELSE CONCAT(if(vtiger_salesorder.title=\".\" or vtiger_salesorder.title=\"-\",\"\",vtiger_salesorder.title ),\" \",if(vtiger_salesorder.firstname=\".\" or vtiger_salesorder.firstname=\"-\",\"\",vtiger_salesorder.firstname),\" \", if(vtiger_salesorder.surname=\".\" or vtiger_salesorder.surname=\"-\",\"\",vtiger_salesorder.surname)) END)As companyName,\r\n\t \r\n(SELECT\r\n\tREPLACE( IF(vtiger_inventoryproductrel.widthmeasuretype='inch',Round(softMax_SalesOrderChildSafety.totalchaincorddrop*25.4,0),\r\n\tIF(vtiger_inventoryproductrel.widthmeasuretype='cm',(softMax_SalesOrderChildSafety.totalchaincorddrop*10),\r\n\tIF(vtiger_inventoryproductrel.widthmeasuretype='m',(softMax_SalesOrderChildSafety.totalchaincorddrop*1000),softMax_SalesOrderChildSafety.totalchaincorddrop))), '-', '')\r\n\tFROM\r\n\tsoftMax_ChildSafetySub \r\n\tInner join softMax_SalesOrderChildSafety ON softMax_SalesOrderChildSafety.childsafetyrequired = softMax_ChildSafetySub.subid\r\nWhere (vtiger_salesorder.salesorderid = softMax_SalesOrderChildSafety.salesorderid\r\nAND softMax_ChildSafetySub.productid = vtiger_products.productid\r\nAND softMax_SalesOrderChildSafety.inventoryproductrelsequenceno = vtiger_inventoryproductrel.sequence_no ) Limit 0,1) As Childallowance,\r\n\r\n(SELECT\r\n\tsoftMax_ChildSafetySub.childsafetysubname\r\n\tFROM\r\n\tsoftMax_ChildSafetySub \r\n\tInner join softMax_SalesOrderChildSafety ON softMax_SalesOrderChildSafety.chaincordsystem = softMax_ChildSafetySub.subid\r\nWhere (vtiger_salesorder.salesorderid = softMax_SalesOrderChildSafety.salesorderid\r\nAND softMax_ChildSafetySub.productid = vtiger_products.productid\r\nAND softMax_SalesOrderChildSafety.inventoryproductrelsequenceno = vtiger_inventoryproductrel.sequence_no ) Limit 0,1) As Chainsystem,\r\n\r\n(SELECT IF(vtiger_inventoryproductrel.widthmeasuretype='inch',Round(vtiger_inventoryproductrel.width*25.4,0),\r\n\tIF(vtiger_inventoryproductrel.widthmeasuretype='cm',(vtiger_inventoryproductrel.width*10),\r\n\tIF(vtiger_inventoryproductrel.widthmeasuretype='m',(vtiger_inventoryproductrel.width*1000),vtiger_inventoryproductrel.width)))) As width,\r\n\r\n(SELECT IF(vtiger_inventoryproductrel.widthmeasuretype='inch',Round(vtiger_inventoryproductrel.drope*25.4,0),\r\n\tIF(vtiger_inventoryproductrel.widthmeasuretype='cm',(vtiger_inventoryproductrel.drope*10),\r\n\tIF(vtiger_inventoryproductrel.widthmeasuretype='m',(vtiger_inventoryproductrel.drope*1000),vtiger_inventoryproductrel.drope)))) As drope,\r\n\r\nIF(vtiger_inventoryproductrel.widthmeasuretype='inch',\r\nIF(softMax_ApplicationSetup.fraction='on',\r\n IF(vtiger_inventoryproductrel.widthfraction='0','',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='1',' 1/8',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='2',' 1/4',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='3',' 3/8',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='4',' 1/2',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='5',' 5/8',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='6',' 3/4',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='7',' 7/8',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='9',' 1/16',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='10',' 3/16',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='11',' 5/16',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='12',' 7/16',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='13',' 9/16',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='14',' 11/16',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='15',' 13/16',\r\n\tIF(vtiger_inventoryproductrel.widthfraction='16',' 15/16','')))))))))))))))),''),'') as widthfraction,\r\n\t\r\n\t\tIF(vtiger_inventoryproductrel.widthmeasuretype='inch',\r\n\tIF(softMax_ApplicationSetup.fraction='on',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='0','',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='1',' 1/8',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='2',' 1/4',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='3',' 3/8',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='4',' 1/2',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='5',' 5/8',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='6',' 3/4',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='7',' 7/8',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='9',' 1/16',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='10',' 3/16',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='11',' 5/16',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='12',' 7/16',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='13',' 9/16',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='14',' 11/16',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='15',' 13/16',\r\n\tIF(vtiger_inventoryproductrel.dropfraction='16',' 15/16','')))))))))))))))),''),'') as dropfraction,\r\n\r\n(SELECT\r\n\tIF(softMax_ProductsParameter.parameterName = 'Width', softMax_SalesOrder.value, NULL) AS SWidth\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND softMax_ProductsParameter.parameterName='Width' Limit 0,1) As SWidth,\r\n\r\n(SELECT\r\n\tsoftMax_SalesOrder.value\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterName='Height' or softMax_ProductsParameter.parameterName='Drop') Limit 0,1) As SDrop,\r\n\r\n(SELECT\r\n\tsoftMax_SalesOrder.value\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterName='Location' or softMax_ProductsParameter.parameterName='Room') Limit 0,1) As Locations,\r\n\r\n\r\n(SELECT\r\n\tsoftMax_SalesOrder.value\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterName='Further Instructions' or softMax_ProductsParameter.parameterName='Special Instructions' or softMax_ProductsParameter.parameterName='Special Instruction') Limit 0,1) As FurtherInstructions,\r\n\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'Poles & Finials Colours' Limit 0,1) AS PolesFinialsColoursEdit,\r\n\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Shapes & Finishes') Limit 0,1) AS ShapesFinishes,\r\n\r\n\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Pulls & Extras') Limit 0,1) AS PullsExtrasEdit,\r\n\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Roll' or softMax_ProductsParameter.parameterName = 'Reverse Roll') Limit 0,1) AS Roll,\r\n\r\n(SELECT\r\n\tIF(softMax_ProductsParameter.parameterName = 'Chain Colour', softMax_EditableList.Name, NULL) AS ChainColour\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'Chain Colour' Limit 0,1) AS ChainColour,\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Brackets' or softMax_ProductsParameter.parameterName = 'Bracket' or softMax_ProductsParameter.parameterName = 'Bracket Colour') Limit 0,1) AS Brackets,\r\n\r\n(SELECT\r\n\t softMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Control' or softMax_ProductsParameter.parameterName = 'Controls' or softMax_ProductsParameter.parameterName = 'Control Type' or softMax_ProductsParameter.parameterName = 'Control Side') Limit 0,1) AS Controls,\r\n\r\n(SELECT\r\n\t softMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Control Side' or softMax_ProductsParameter.parameterName = 'Control Side') Limit 0,1) AS ControlSide,\r\n\r\n\r\n(SELECT \r\n\tIF(softMax_ProductsParameter.parameterName = 'Comp' or softMax_ProductsParameter.parameterName = 'Components', softMax_EditableList.Name, NULL) AS Components\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Comp' or softMax_ProductsParameter.parameterName = 'Components' ) Limit 0,1) AS Components,\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Blind or Recess' or softMax_ProductsParameter.parameterName = 'Blind Mount' or softMax_ProductsParameter.parameterName = 'Mount' or softMax_ProductsParameter.parameterName = 'Fabric or Recess' or softMax_ProductsParameter.parameterName = 'Fabric or Recess' or softMax_ProductsParameter.parameterName = 'Material or Recess') Limit 0,1) AS BorR,\r\n\r\n(SELECT\r\n\tIF(softMax_ProductsParameter.parameterName = 'Colour', softMax_EditableList.Name, NULL) AS HeadrailColour\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere (softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'Colour') Limit 0,1) AS HeadrailColour,\r\n\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Braid') Limit 0,1) AS Braid,\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Braid Colours') Limit 0,1) AS BraidColoursEdit,\r\n\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Pole Type' or softMax_ProductsParameter.parameterName = 'Poles & Finials Colours') Limit 0,1) AS PoleType,\r\n\r\n(SELECT\r\n\tIF(softMax_ProductsParameter.parameterName = 'Pull Cord', softMax_EditableList.Name, NULL) AS PullCord\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'Pull Cord' Limit 0,1) AS PullCord,\r\n\r\n(SELECT\r\n\tIF(softMax_ProductsParameter.parameterName = 'Rail Colour', softMax_EditableList.Name, NULL) AS RailColour\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'Rail Colour' Limit 0,1) AS RailColour,\r\n\r\n(SELECT\r\n\tIF(softMax_ProductsParameter.parameterName = 'Size Type', softMax_EditableList.Name, NULL) AS SizeType\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'Size Type' Limit 0,1) AS SizeType,\r\n\r\n\r\n(SELECT\r\n\tIF(softMax_ProductsParameter.parameterName = 'System Type', softMax_EditableList.Name, NULL) AS SystemType\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'System Type' Limit 0,1) AS SystemType,\r\n\r\n\r\n(SELECT\r\n\tIF(softMax_ProductsParameter.parameterName = 'Headrail Type', softMax_EditableList.Name, NULL) AS HeadrailType\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'Headrail Type' Limit 0,1) AS HeadrailType,\r\n\r\n\r\n\r\n(SELECT\r\n\tif(softMax_ComponentSub.allowance>0,softMax_ComponentSub.allowance,softMax_EditableSub.allowance)\r\n\tFROM\r\n\tvtiger_salesorder\r\n\tINNER Join softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\nleft outer join softMax_ComponentSub ON softMax_FixedpriceSalesorder.fixedPriceId = softMax_ComponentSub.priceid\r\nleft outer JOIN softMax_EditableSub ON softMax_FixedpriceSalesorder.fixedPriceId = softMax_EditableSub.editableListId\r\nWhere (vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_FixedpriceSalesorder.sequenceno = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_FixedpriceSalesorder.fixedPriceId = softMax_EditableSub.editableListId or softMax_ComponentSub.priceid = softMax_FixedpriceSalesorder.fixedPriceId) \r\nAND (softMax_EditableSub.parametername Like '%Chain%' or softMax_ComponentSub.parametername Like '%Chain%')) Limit 0,1) AS ChainAllowance,\r\n\r\n\r\n\r\n\r\n(SELECT\r\n\tif(softMax_ComponentSub.allowance>0,softMax_ComponentSub.allowance,softMax_EditableSub.allowance)\r\n\tFROM\r\n\tvtiger_salesorder\r\n\tINNER Join softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\nleft outer join softMax_ComponentSub ON softMax_FixedpriceSalesorder.fixedPriceId = softMax_ComponentSub.priceid\r\nleft outer JOIN softMax_EditableSub ON softMax_FixedpriceSalesorder.fixedPriceId = softMax_EditableSub.editableListId\r\nWhere (vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_FixedpriceSalesorder.sequenceno = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_FixedpriceSalesorder.fixedPriceId = softMax_EditableSub.editableListId or softMax_ComponentSub.priceid = softMax_FixedpriceSalesorder.fixedPriceId) \r\nAND (softMax_EditableSub.parametername Like '%Drop%' or softMax_ComponentSub.parametername Like '%Drop%')) Limit 0,1) AS DropAllowance,\r\n\r\n\r\n\r\n(SELECT\r\n\tif(softMax_ComponentSub.allowance>0,softMax_ComponentSub.allowance,softMax_EditableSub.allowance)\r\n\tFROM\r\n\tvtiger_salesorder\r\n\tINNER Join softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\nleft outer join softMax_ComponentSub ON softMax_FixedpriceSalesorder.fixedPriceId = softMax_ComponentSub.priceid\r\nleft outer JOIN softMax_EditableSub ON softMax_FixedpriceSalesorder.fixedPriceId = softMax_EditableSub.editableListId\r\nWhere (vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_FixedpriceSalesorder.sequenceno = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_FixedpriceSalesorder.fixedPriceId = softMax_EditableSub.editableListId or softMax_ComponentSub.priceid = softMax_FixedpriceSalesorder.fixedPriceId) \r\nAND (softMax_EditableSub.parametername Like '%Recess%' or softMax_ComponentSub.parametername Like '%Recess%')) Limit 0,1) AS RecessAllowance,\r\n\r\n\r\n\r\n(SELECT\r\n\tif(softMax_ComponentSub.allowance>0,softMax_ComponentSub.allowance,softMax_EditableSub.allowance)\r\n\tFROM\r\n\tvtiger_salesorder\r\n\tINNER Join softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\nleft outer join softMax_ComponentSub ON softMax_FixedpriceSalesorder.fixedPriceId = softMax_ComponentSub.priceid\r\nleft outer JOIN softMax_EditableSub ON softMax_FixedpriceSalesorder.fixedPriceId = softMax_EditableSub.editableListId\r\nWhere (vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_FixedpriceSalesorder.sequenceno = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_FixedpriceSalesorder.fixedPriceId = softMax_EditableSub.editableListId or softMax_ComponentSub.priceid = softMax_FixedpriceSalesorder.fixedPriceId) \r\nAND (softMax_EditableSub.parametername Like '%System%' or softMax_ComponentSub.parametername Like '%System%')) Limit 0,1) AS SystemAllowance,\r\n\r\n\r\n\r\n(SELECT\r\n\tsoftMax_EditableSubSubList.productSubSubName\r\n\tFROM\r\n\tsoftMax_SalesOrderSub\r\n\tInner Join softMax_EditParameterTypeSub ON softMax_EditParameterTypeSub.productTypeSubId = softMax_SalesOrderSub.parametertypesubid\r\nInner Join softMax_EditableSubSubList ON softMax_EditParameterTypeSub.productTypeSubId = softMax_EditableSubSubList.productTypeSubId AND softMax_SalesOrderSub.valuee = softMax_EditableSubSubList.productTypeSubSubId\r\nwhere (softMax_SalesOrderSub.salesorderid = vtiger_inventoryproductrel.id OR softMax_SalesOrderSub.salesorderid IS NULL) \r\nAND (softMax_SalesOrderSub.inventoryproductrelSequenceNo =vtiger_inventoryproductrel.sequence_no OR softMax_SalesOrderSub.inventoryproductrelSequenceNo IS NULL) AND softMax_SalesOrderSub.status = '0' Limit 0,1) As Colour,\r\n\r\n(SELECT\r\n\tIF(softMax_EditParameterTypeSub.parameterName = 'Colours' or softMax_EditParameterTypeSub.parameterName = 'Colour', softMax_SalesOrderSub.valuee, NULL) AS Colourtext\r\n\tFROM\r\n\tsoftMax_SalesOrderSub\r\n\tInner Join softMax_EditParameterTypeSub ON softMax_EditParameterTypeSub.productTypeSubId = softMax_SalesOrderSub.parametertypesubid\r\nwhere (softMax_SalesOrderSub.salesorderid = vtiger_inventoryproductrel.id OR softMax_SalesOrderSub.salesorderid IS NULL)\r\nAND (softMax_SalesOrderSub.inventoryproductrelSequenceNo =vtiger_inventoryproductrel.sequence_no OR softMax_SalesOrderSub.inventoryproductrelSequenceNo IS NULL) AND softMax_SalesOrderSub.status = '0' Limit 0,1) As Colourtext,\r\n\r\n(SELECT CASE WHEN \r\n(SELECT\r\n\tsoftMax_EditableSubSubList.productSubSubName\r\n\tFROM\r\n\tsoftMax_SalesOrderSub\r\n\tInner Join softMax_EditParameterTypeSub ON softMax_EditParameterTypeSub.productTypeSubId = softMax_SalesOrderSub.parametertypesubid\r\nInner Join softMax_EditableSubSubList ON softMax_EditParameterTypeSub.productTypeSubId = softMax_EditableSubSubList.productTypeSubId AND softMax_SalesOrderSub.valuee = softMax_EditableSubSubList.productTypeSubSubId\r\nwhere (softMax_SalesOrderSub.salesorderid = vtiger_inventoryproductrel.id OR softMax_SalesOrderSub.salesorderid IS NULL) \r\nAND (softMax_SalesOrderSub.inventoryproductrelSequenceNo =vtiger_inventoryproductrel.sequence_no OR softMax_SalesOrderSub.inventoryproductrelSequenceNo IS NULL) AND softMax_SalesOrderSub.status = '0' Limit 0,1) !='' \r\nTHEN \r\n(SELECT\r\n\tsoftMax_EditableSubSubList.productSubSubName\r\n\tFROM\r\n\tsoftMax_SalesOrderSub\r\n\tInner Join softMax_EditParameterTypeSub ON softMax_EditParameterTypeSub.productTypeSubId = softMax_SalesOrderSub.parametertypesubid\r\nInner Join softMax_EditableSubSubList ON softMax_EditParameterTypeSub.productTypeSubId = softMax_EditableSubSubList.productTypeSubId AND softMax_SalesOrderSub.valuee = softMax_EditableSubSubList.productTypeSubSubId\r\nwhere (softMax_SalesOrderSub.salesorderid = vtiger_inventoryproductrel.id OR softMax_SalesOrderSub.salesorderid IS NULL) \r\nAND (softMax_SalesOrderSub.inventoryproductrelSequenceNo =vtiger_inventoryproductrel.sequence_no OR softMax_SalesOrderSub.inventoryproductrelSequenceNo IS NULL) AND softMax_SalesOrderSub.status = '0' Limit 0,1) \r\nELSE \r\n(SELECT\r\n\tIF((softMax_EditParameterTypeSub.parameterName = 'Colours' or softMax_EditParameterTypeSub.parameterName = 'Colour'), softMax_SalesOrderSub.valuee, NULL) AS Colourtext\r\n\tFROM\r\n\tsoftMax_SalesOrderSub\r\n\tInner Join softMax_EditParameterTypeSub ON softMax_EditParameterTypeSub.productTypeSubId = softMax_SalesOrderSub.parametertypesubid\r\nwhere (softMax_SalesOrderSub.salesorderid = vtiger_inventoryproductrel.id OR softMax_SalesOrderSub.salesorderid IS NULL)\r\nAND (softMax_SalesOrderSub.inventoryproductrelSequenceNo =vtiger_inventoryproductrel.sequence_no OR softMax_SalesOrderSub.inventoryproductrelSequenceNo IS NULL) AND softMax_SalesOrderSub.status = '0' Limit 0,1) \r\nEND) As newcolourlisttext,\r\n\r\n(SELECT\r\n\tsoftMax_EditableSubList.Name\r\n\tFROM\r\n\tsoftMax_EditableSubList\r\n\tInner Join softMax_SalesOrderProductTypeValue ON softMax_SalesOrderProductTypeValue.parameterTypeSubSubId = softMax_EditableSubList.parameterTypeSubSubId\r\nwhere (vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nAND vtiger_inventoryproductrel.id = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrderProductTypeValue.salesorderid AND softMax_SalesOrderProductTypeValue.status = '0' \r\nAND vtiger_inventoryproductrel.sequence_no = softMax_SalesOrderProductTypeValue.inventoryproductrelSequenceNo) Limit 0,1 ) As Fabric,\r\n\r\n(SELECT\r\n\tsoftMax_EditableSubList.Name\r\n\tFROM\r\n\tsoftMax_SalesOrderProductTypeSub\r\n\tInner Join softMax_ParameterTypeSub ON softMax_ParameterTypeSub.parameterTypeSubId = softMax_SalesOrderProductTypeSub.parameterTypeSubSubId\r\nInner Join softMax_EditableSubList ON softMax_ParameterTypeSub.parameterTypeSubId = softMax_EditableSubList.parameterTypeSubId AND \r\nsoftMax_SalesOrderProductTypeSub.value = softMax_EditableSubList.parameterTypeSubSubId\r\nwhere (softMax_SalesOrderProductTypeSub.salesorderid = vtiger_inventoryproductrel.id)\r\nAND (softMax_ParameterTypeSub.parameterName = 'Pole Colour')\r\nAND (softMax_SalesOrderProductTypeSub.inventoryproductrelSequenceNo =vtiger_inventoryproductrel.sequence_no) AND softMax_SalesOrderProductTypeSub.status = '0' Limit 0,1) As SubPoleColour,\r\n\r\n(SELECT\r\n\tsoftMax_ParameterType.productTypeSubName\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_ParameterType ON softMax_SalesOrder.parameterId = softMax_ParameterType.parameterId AND softMax_SalesOrder.value = softMax_ParameterType.parameterTypeId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterName = 'Product Type' or softMax_ProductsParameter.parameterName = 'Pricing Band') Limit 0,1) AS Ptype,\r\n\r\n\r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND softMax_FixedpriceSalesorder.parameterListId=softMax_ProductsParameter.parameterListId\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterName = 'Extras'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As ExtrasNew,\r\n\r\n(SELECT \r\n\tsoftMax_FixedpriceSalesorder.componentname\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND softMax_FixedpriceSalesorder.parameterListId=softMax_ProductsParameter.parameterListId\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND (softMax_ProductsParameter.parameterName = 'Extras' And softMax_FixedpriceSalesorder.componentname='Side Channel')\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) Limit 0,1) As ExtrasNewSideChannel,\r\n\r\n(SELECT \r\n\tsoftMax_FixedpriceSalesorder.componentname\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND softMax_FixedpriceSalesorder.parameterListId=softMax_ProductsParameter.parameterListId\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND (softMax_ProductsParameter.parameterName = 'Extras' And softMax_FixedpriceSalesorder.componentname='Bottom Channel')\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) Limit 0,1) As ExtrasNewBottomChannel,\r\n\r\n\r\n(SELECT \r\n\tsoftMax_FixedpriceSalesorder.componentname\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND softMax_FixedpriceSalesorder.parameterListId=softMax_ProductsParameter.parameterListId\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND (softMax_ProductsParameter.parameterName = 'Extras' And softMax_FixedpriceSalesorder.componentname='Hanger - Used in Pocket Installation - Color: White')\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) Limit 0,1) As ExtrasNewHanger,\r\n\r\n(SELECT \r\n\tsoftMax_FixedpriceSalesorder.componentname\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND softMax_FixedpriceSalesorder.parameterListId=softMax_ProductsParameter.parameterListId\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND (softMax_ProductsParameter.parameterName = 'Extras' And softMax_FixedpriceSalesorder.componentname='3 inch Flap - Used in Pocket Installation - Color: White')\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) Limit 0,1) As ExtrasNewInchFlap,\r\n\r\n\r\n(SELECT \r\n\tsoftMax_FixedpriceSalesorder.componentname\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND softMax_FixedpriceSalesorder.parameterListId=softMax_ProductsParameter.parameterListId\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND (softMax_ProductsParameter.parameterName = 'Extras' And softMax_FixedpriceSalesorder.componentname='Free Form Fascia - Custom Size, 10ft lengths, Color: Clear Anodized')\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) Limit 0,1) As ExtrasNewFreeFormFascia,\r\n\r\n\r\n\r\n(SELECT\r\nGROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM\r\nsoftMax_SubFixedpriceSalesorder\r\ninner join vtiger_salesorder on softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\ninner join softMax_SubComponent on softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\ninner join softMax_Component on softMax_Component.priceid = softMax_SubComponent.component_id\r\nwhere vtiger_salesorder.salesorderid = softMax_SubFixedpriceSalesorder.salesorderid \r\nand vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id \r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\nand softMax_SubComponent.status = 0 and (softMax_SubComponent.componentname = \"Side Channel Color\")\r\nand softMax_SubComponent.productid = vtiger_products.productid \r\nand softMax_Component.productid = vtiger_products.productid \r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1 limit 0,1) As SideChannelColorSubComp,\r\n\r\n(SELECT\r\nGROUP_CONCAT(softMax_SubFixedpriceSalesorder.qty SEPARATOR ', ')\r\nFROM\r\nsoftMax_SubFixedpriceSalesorder\r\ninner join vtiger_salesorder on softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\ninner join softMax_SubComponent on softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\ninner join softMax_Component on softMax_Component.priceid = softMax_SubComponent.component_id\r\nwhere vtiger_salesorder.salesorderid = softMax_SubFixedpriceSalesorder.salesorderid \r\nand vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id \r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\nand softMax_SubComponent.status = 0 and (softMax_SubComponent.componentname = \"Side Channel Color\")\r\nand softMax_SubComponent.productid = vtiger_products.productid \r\nand softMax_Component.productid = vtiger_products.productid \r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1 limit 0,1) As SideChannelColorQtySubComp,\r\n\r\n(SELECT\r\nGROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM\r\nsoftMax_SubFixedpriceSalesorder\r\ninner join vtiger_salesorder on softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\ninner join softMax_SubComponent on softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\ninner join softMax_Component on softMax_Component.priceid = softMax_SubComponent.component_id\r\nwhere vtiger_salesorder.salesorderid = softMax_SubFixedpriceSalesorder.salesorderid \r\nand vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id \r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\nand softMax_SubComponent.status = 0 and (softMax_SubComponent.componentname = \"Side Channel Size (Height)\")\r\nand softMax_SubComponent.productid = vtiger_products.productid \r\nand softMax_Component.productid = vtiger_products.productid \r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 12 limit 0,1) as SideChannelSizeSubComp,\r\n\r\n(SELECT\r\nGROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM\r\nsoftMax_SubFixedpriceSalesorder\r\ninner join vtiger_salesorder on softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\ninner join softMax_SubComponent on softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\ninner join softMax_Component on softMax_Component.priceid = softMax_SubComponent.component_id\r\nwhere vtiger_salesorder.salesorderid = softMax_SubFixedpriceSalesorder.salesorderid \r\nand vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id \r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\nand softMax_SubComponent.status = 0 and (softMax_SubComponent.componentname = \"Bottom Channel Color\")\r\nand softMax_SubComponent.productid = vtiger_products.productid \r\nand softMax_Component.productid = vtiger_products.productid \r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1 limit 0,1) As BottomChannelColorSubComp,\r\n\r\n(SELECT\r\nGROUP_CONCAT(softMax_SubFixedpriceSalesorder.qty SEPARATOR ', ')\r\nFROM\r\nsoftMax_SubFixedpriceSalesorder\r\ninner join vtiger_salesorder on softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid \r\ninner join softMax_SubComponent on softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\ninner join softMax_Component on softMax_Component.priceid = softMax_SubComponent.component_id\r\nwhere vtiger_salesorder.salesorderid = softMax_SubFixedpriceSalesorder.salesorderid \r\nand vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id \r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\r\nand softMax_SubComponent.status = 0 and (softMax_SubComponent.componentname = \"Bottom Channel Color\")\r\nand softMax_SubComponent.productid = vtiger_products.productid \r\nand softMax_Component.productid = vtiger_products.productid \r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1 limit 0,1) As BottomChannelColorQtySubComp,\r\n\r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND softMax_FixedpriceSalesorder.parameterListId=softMax_ProductsParameter.parameterListId\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterName = 'Mount Type'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As MountType,\r\n\r\n\r\n\r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND softMax_FixedpriceSalesorder.parameterListId=softMax_ProductsParameter.parameterListId\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterName = 'System Type'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As SystemTypeExtrasNew,\r\n\r\n\r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND (softMax_ProductsParameter.parameterName = 'Shape/Scallop' or softMax_ProductsParameter.parameterName = 'Scallops')\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As ShapeScallopExtras,\r\n\r\n\r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterName = 'Braid'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As BraidsExtras,\r\n\r\n\r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterName = 'MountType'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As MountTypeExtras,\r\n\r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterName = 'Motorized'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As MotorizedExtras,\r\n\r\n(Select\r\n\tformula_values.value\r\n\tfrom\r\n\tformula_values\r\n\tInner Join formula ON formula_values.variable_id = formula.id\r\nWhere formula_values.salesorder_id = vtiger_inventoryproductrel.id\r\nAND formula_values.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.sequence_no = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.variable_id = formula.id\r\nAND formula_values.salesorder_id = vtiger_salesorder.salesorderid\r\nAND (formula_values.variable_name = 'fabric size' or formula_values.variable_name = 'Fabric Size') and formula_values.status = 0 Order by formula_values.id desc limit 0,1) as FabricSizeFormula,\r\n\r\n\r\n(Select\r\n\tformula_values.value\r\n\tfrom\r\n\tformula_values\r\n\tInner Join formula ON formula_values.variable_id = formula.id\r\nWhere formula_values.salesorder_id = vtiger_inventoryproductrel.id\r\nAND formula_values.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.sequence_no = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.variable_id = formula.id\r\nAND formula_values.salesorder_id = vtiger_salesorder.salesorderid\r\nAND (formula_values.variable_name = 'Fabric Amount' or formula_values.variable_name = 'fabric amount') and formula_values.status = 0 Order by formula_values.id desc limit 0,1) as FabricAmountFormula,\r\n\r\n(Select\r\n\tformula_values.value\r\n\tfrom\r\n\tformula_values\r\n\tInner Join formula ON formula_values.variable_id = formula.id\r\nWhere formula_values.salesorder_id = vtiger_inventoryproductrel.id\r\nAND formula_values.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.sequence_no = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.variable_id = formula.id\r\nAND formula_values.salesorder_id = vtiger_salesorder.salesorderid\r\nAND formula_values.variable_name = 'Chain Length' and formula_values.status = 0 Order by formula_values.id desc limit 0,1) as ChainLengthFormula,\r\n\r\n\r\n(Select\r\n\tformula_values.value\r\n\tfrom\r\n\tformula_values\r\n\tInner Join formula ON formula_values.variable_id = formula.id\r\nWhere formula_values.salesorder_id = vtiger_inventoryproductrel.id\r\nAND formula_values.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.sequence_no = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.variable_id = formula.id\r\nAND formula_values.salesorder_id = vtiger_salesorder.salesorderid\r\nAND formula_values.variable_name = 'Cord Length' and formula_values.status = 0 Order by formula_values.id desc limit 0,1) as CordLengthFormula,\r\n\r\n(Select\r\n\tformula_values.value\r\n\tfrom\r\n\tformula_values\r\n\tInner Join formula ON formula_values.variable_id = formula.id\r\nWhere formula_values.salesorder_id = vtiger_inventoryproductrel.id\r\nAND formula_values.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.sequence_no = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.variable_id = formula.id\r\nAND formula_values.salesorder_id = vtiger_salesorder.salesorderid\r\nAND formula_values.variable_name = 'Fabric Qty' and formula_values.status = 0 Order by formula_values.id desc limit 0,1) as FabricQtyFormula,\r\n\r\n\r\n(Select\r\n\tformula_values.value\r\n\tfrom\r\n\tformula_values\r\n\tInner Join formula ON formula_values.variable_id = formula.id\r\nWhere formula_values.salesorder_id = vtiger_inventoryproductrel.id\r\nAND formula_values.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.sequence_no = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.variable_id = formula.id\r\nAND formula_values.salesorder_id = vtiger_salesorder.salesorderid\r\nAND formula_values.variable_name = 'Cloth width' and formula_values.status = 0 Order by formula_values.id desc limit 0,1) as ClothwidthFormula,\r\n\r\n\r\n\r\n(Select\r\n\tformula_values.value\r\n\tfrom\r\n\tformula_values\r\n\tInner Join formula ON formula_values.variable_id = formula.id\r\nWhere formula_values.salesorder_id = vtiger_inventoryproductrel.id\r\nAND formula_values.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.sequence_no = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND formula_values.variable_id = formula.id\r\nAND formula_values.salesorder_id = vtiger_salesorder.salesorderid\r\nAND formula_values.variable_name = 'Cloth drop' and formula_values.status = 0 Order by formula_values.id desc limit 0,1) as ClothdropFormula,\r\n\r\n(SELECT\r\n\tsoftMax_ChildSafetySub.childsafetysubname\r\n\tFROM\r\n\tsoftMax_ChildSafetySub \r\n\tInner join softMax_SalesOrderChildSafety ON softMax_SalesOrderChildSafety.chaincordsystem = softMax_ChildSafetySub.subid\r\nWhere (vtiger_salesorder.salesorderid = softMax_SalesOrderChildSafety.salesorderid\r\nAND softMax_ChildSafetySub.productid = vtiger_products.productid\r\nAND softMax_SalesOrderChildSafety.inventoryproductrelsequenceno = vtiger_inventoryproductrel.sequence_no ) Limit 0,1) As Chainsystem\r\n\r\nFROM\r\nvtiger_inventoryproductrel \r\nInner Join vtiger_products On vtiger_inventoryproductrel.productid = vtiger_products.productid \r\ninner Join vtiger_salesorder On vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nLEFT OUTER JOIN softMax_AlternateDeliveryAddress ON vtiger_salesorder.deliveryaddressid = softMax_AlternateDeliveryAddress.alternateAddressSeq\r\n\r\nJoin \r\n(\r\nSELECT\r\n\tSEQ.SeqValue\r\n\tFROM\r\n\t(\r\nSELECT\r\n\t( TENS.SeqValue + ONES.SeqValue) SeqValue\r\n\t\tFROM\r\n\t\t(\r\nSELECT 0 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 1 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 2 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 3 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 4 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 5 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 6 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 7 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 8 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 9 SeqValue\r\n\t\t) ONES\r\n\t\tCROSS JOIN\r\n\t\t(\r\nSELECT 0 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 10 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 20 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 30 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 40 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 50 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 60 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 70 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 80 SeqValue\r\n\t\t\t\t\t\tUNION ALL\r\nSELECT 90 SeqValue\r\n\t\t) TENS\r\n\t) SEQ\r\n) As Numbers\r\nOn Numbers.SeqValue < vtiger_inventoryproductrel.quantity,\r\nvtiger_organizationdetails, softMax_ApplicationSetup\r\nwhere (vtiger_products.product_no='2513' and vtiger_salesorder.salesorder_no='{Orno}' AND vtiger_inventoryproductrel.onhold = '0') AND (vtiger_inventoryproductrel.status = '0') ORDER BY vtiger_inventoryproductrel.custom_seq" } }, "Databases": { "0": { "Ident": "StiMySqlDatabase", "Name": "my", "Alias": "my", "ConnectionStringEncrypted": "41Zpa2Jco/HLRynM5Vw0Y4twdcJhWlqEYlqhzGh0YWflbMsJSwjL6flJ1ZhqXGUXjWppK01ZQ4HiW9WY6SWgXot0" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page7", "Guid": "08c0d1fec8f64efb92d278e760352ec4", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{Type == \"Works Order\"}" }, "Enabled": false, "Font": ";10;;", "BorderSides": "None" }, "1": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{Type == \"BOM Works Order\"}" }, "Enabled": false, "Font": ";10;;", "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text361", "Guid": "7b46bf0694a88f6464a54910fd27c3a9", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "31.8,14.4,1.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.ClothDropinch}" }, "Font": ";10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "1": { "Ident": "StiText", "Name": "Text362", "Guid": "ab0079ff2c28152e4e07357f5fe31898", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "29,14.4,2.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "ClothDropinch" }, "Font": ";10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "2": { "Ident": "StiDataBand", "Name": "DataBand13", "ClientRectangle": "0,0.4,9.2,2.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text363", "Guid": "59b7a6391b05e6eb80fe5e9e156c8201", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.1,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text364", "Guid": "5aa89c2f48bc1957854895be8dce86c8", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.89,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Fabric} {IIF(DataSource1.newcolourlisttext == \"0\",\"\",DataSource1.newcolourlisttext)} " }, "CanBreak": true, "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text365", "Guid": "1611867e3b9649bfd3cd0e342534389d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.7,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.companyName}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text366", "Guid": "58793117174a16cac09bc2b5475000e4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.productname}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text367", "Guid": "434d51ac6d8fc2b5c7bc7bdef062fa9e", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Room" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text368", "Guid": "60e4df56bf3f45a69b831b0d442da474", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,0.7,3.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Locations}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text369", "Guid": "ace04364bb93976ee2698fb54957d2a5", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "5,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{LineThrough} of {Count()}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text370", "Guid": "8e7f5bd06355cd7047a7901053efb3f2", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,1.3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.SWidth} {DataSource1.widthfraction} X {DataSource1.SDrop} {DataSource1.dropfraction}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text371", "Guid": "e3a88bc3719cbb6bc73053e616272485", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.3,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Size" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text372", "Guid": "6a6e49d75c464d0cad2887fb281b5779", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.89,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "CanBreak": true, "HorAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text373", "Guid": "e6a39dcc000dce12ffc0bb31bfacdcc5", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.3,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.ControlSide ==\"Left\",\"CL\",IIF(DataSource1.ControlSide ==\"Right\",\"CR\",DataSource1.ControlSide))}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" } }, "MinHeight": 2.6, "MaxHeight": 2.6, "SkipFirst": false, "DataSourceName": "DataSource1", "ColumnDirection": "DownThenAcross", "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{DataSource1.salesorder_no==Orno}" } } } }, "3": { "Ident": "StiChildBand", "Name": "ChildBand7", "ClientRectangle": "0,3.8,9.2,2.6", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text374", "Guid": "8b1499f7aafed1647970745ebbd8434d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.1,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text375", "Guid": "a99eee75e025c6b4f68e4c295fcdbed2", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.89,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Fabric} {IIF(DataSource1.newcolourlisttext == \"0\",\"\",DataSource1.newcolourlisttext)} " }, "CanBreak": true, "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text376", "Guid": "77e2c496cdcd50a5fc5d745fbb759ba4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.7,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.companyName}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text377", "Guid": "7fdf6f12ddf8ef80500662bee787e4cd", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.productname}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text378", "Guid": "1d0efce008c69a66bd4b5e075bd85f61", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Room" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text379", "Guid": "99f5ea7e1e00b91dc1bfd07b51c3ca39", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,0.7,3.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Locations}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text380", "Guid": "cb7a2ae3dd5dbb11da5337cf119061fd", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "5,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{LineThrough} of {Count()}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text381", "Guid": "31ffa9cd74f80b79207abfccb5d53333", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,1.3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.SWidth} {DataSource1.widthfraction} X {DataSource1.SDrop} {DataSource1.dropfraction}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text382", "Guid": "26a293fff3bd657c630941e6afb4190b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.3,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Size" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text383", "Guid": "13d810664eb9f1ce42b017d89560c726", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.89,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "CanBreak": true, "HorAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text384", "Guid": "d5b07b036409b1c66a8dbb7ec0b5aa60", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.3,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.ControlSide ==\"Left\",\"CL\",IIF(DataSource1.ControlSide ==\"Right\",\"CR\",DataSource1.ControlSide))}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" } }, "MinHeight": 2.6, "MaxHeight": 2.6 }, "4": { "Ident": "StiChildBand", "Name": "ChildBand6", "ClientRectangle": "0,7.2,9.2,2.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1[\"ExtrasNewSideChannel\"] == DBNull.Value}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text385", "Guid": "950723dad210892f498b398abdb2ab7d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.1,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text386", "Guid": "a2dd7cd9047966ef37834eac7aea229c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.89,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Fabric} {IIF(DataSource1.newcolourlisttext == \"0\",\"\",DataSource1.newcolourlisttext)} " }, "CanBreak": true, "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text387", "Guid": "134a21985990f51f7d03fd608a0817df", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.7,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.companyName}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text388", "Guid": "04f87c0e6d31624a0976144d98192051", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Side Channel - {DataSource1.SideChannelColorSubComp}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text389", "Guid": "f25f1f326ba8c1024489a8172b61ecaa", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Room" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text390", "Guid": "d455c2dc60652cdcd7debfd0d0b77467", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,0.7,3.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Locations}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text391", "Guid": "2b3173ab90c48949c2820ce0b8ca9280", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "5,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{LineThrough} of {Count()}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text392", "Guid": "5137dee5930af301c2b8d2696cfa1a6e", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,1.3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.SideChannelSizeSubComp}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text393", "Guid": "581f140cea15a1c66fabf6af8f2da560", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.3,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Size" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text394", "Guid": "11e11c5c7fe1f7200bdb00dfd5ae492b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.89,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "CanBreak": true, "HorAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text395", "Guid": "bdb6e9da21cd58574009d16157f16fc1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.3,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.ControlSide ==\"Left\",\"CL\",IIF(DataSource1.ControlSide ==\"Right\",\"CR\",DataSource1.ControlSide))}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" } }, "MinHeight": 2.6, "MaxHeight": 2.6 }, "5": { "Ident": "StiChildBand", "Name": "ChildBand5", "ClientRectangle": "0,10.6,9.2,2.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1[\"ExtrasNewSideChannel\"] == DBNull.Value}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text396", "Guid": "3ad82561186a48faaca11269573ccda6", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.1,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text397", "Guid": "d522856e7f7d49549bec55567da08d16", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.89,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Fabric} {IIF(DataSource1.newcolourlisttext == \"0\",\"\",DataSource1.newcolourlisttext)} " }, "CanBreak": true, "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text398", "Guid": "7703fc2d5ae744c58a3ad6001b7fb01c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.7,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.companyName}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text399", "Guid": "69888e07c5ce4e15a37f5d84263ceed1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Side Channel - {DataSource1.SideChannelColorSubComp}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text400", "Guid": "c6e0ac40601b4b08bafa41c57c898b79", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Room" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text401", "Guid": "b7861c784b624c33a5abf1a8412dd725", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,0.7,3.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Locations}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text402", "Guid": "c892247ea9cd483293cc382872355216", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "5,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{LineThrough} of {Count()}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text403", "Guid": "aa45333214e044d3ac243eb49d921321", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,1.3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.SideChannelSizeSubComp}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text404", "Guid": "5994a0f1113845bba8fb8866ef828bcc", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.3,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Size" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text405", "Guid": "d6459c79332844d995e7933acf54cc67", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.89,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "CanBreak": true, "HorAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text406", "Guid": "6c91c72f412c4c18b8d0216e54a39598", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.3,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.ControlSide ==\"Left\",\"CL\",IIF(DataSource1.ControlSide ==\"Right\",\"CR\",DataSource1.ControlSide))}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" } }, "MinHeight": 2.6, "MaxHeight": 2.6 }, "6": { "Ident": "StiChildBand", "Name": "ChildBand3", "ClientRectangle": "0,14,9.2,2.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1[\"ExtrasNewBottomChannel\"] == DBNull.Value}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text407", "Guid": "c688765570a2491d825717c6ac96698c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.1,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text408", "Guid": "087a2c4b66a04ca3b6efb2908fdd05a1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.89,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Fabric} {IIF(DataSource1.newcolourlisttext == \"0\",\"\",DataSource1.newcolourlisttext)} " }, "CanBreak": true, "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text409", "Guid": "d55e9f4f1adf44d9a34ad631d9c9fd24", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.7,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.companyName}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text410", "Guid": "bef518c91df646f5802ec83c35335e48", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "BottomChannel - {DataSource1.BottomChannelColorSubComp}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text411", "Guid": "691f048a427f4e7f9b1aff8b5a9fb91f", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Room" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text412", "Guid": "bfcdc39d8e074439a415d16454ed90b7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,0.7,3.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Locations}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text413", "Guid": "1689fad75f3441d0b366e1f4dc32f4a4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "5,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{LineThrough} of {Count()}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text414", "Guid": "c7417e66de4440c7a3b7c4c9e303af1b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,1.3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.BottomChannelColorQtySubComp}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text415", "Guid": "54654de1bd9f4f2e83b8abc2cd0649fa", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.3,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Size" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text416", "Guid": "5e41fabb60a1439780a0e36cd965e592", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.89,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "CanBreak": true, "HorAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text417", "Guid": "b3f51ac9b98a43f58a62a7021e9f8115", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.3,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.ControlSide ==\"Left\",\"CL\",IIF(DataSource1.ControlSide ==\"Right\",\"CR\",DataSource1.ControlSide))}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" } }, "MinHeight": 2.6, "MaxHeight": 2.6 }, "7": { "Ident": "StiChildBand", "Name": "ChildBand4", "ClientRectangle": "0,17.4,9.2,2.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1[\"ExtrasNewHanger\"] == DBNull.Value}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text418", "Guid": "fc2329db8c30fb5df68d3a8274586c94", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.1,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text419", "Guid": "03cacfa07ed208ef6c8572ffcdf0a315", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.89,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Fabric} {IIF(DataSource1.newcolourlisttext == \"0\",\"\",DataSource1.newcolourlisttext)} " }, "CanBreak": true, "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text420", "Guid": "e63d9d1cf608bfe2f643e2d5307d8a19", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.7,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.companyName}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text421", "Guid": "9ba536b5bd8b36f32281707c33bfdb8c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Hanger - Color: White" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text422", "Guid": "e86bb012c18916caa6a1907536b46609", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Room" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text423", "Guid": "4742cb9bf8d33487e029fac71730c800", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,0.7,3.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Locations}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text424", "Guid": "ae0cef7a582d23018e6208511667d4b8", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "5,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{LineThrough} of {Count()}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text425", "Guid": "b167dc8f6b26027d98b1d86db2cb65c1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,1.3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text426", "Guid": "19079b8d0c3aa7ee9b85e7d5fe889e7d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.3,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Size" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text427", "Guid": "943887814993437fb799aa7f8570c5be", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.89,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "CanBreak": true, "HorAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text428", "Guid": "2dbf675d034ddbc362eb3ca27bef940b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.3,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.ControlSide ==\"Left\",\"CL\",IIF(DataSource1.ControlSide ==\"Right\",\"CR\",DataSource1.ControlSide))}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" } }, "MinHeight": 2.6, "MaxHeight": 2.6 }, "8": { "Ident": "StiChildBand", "Name": "ChildBand2", "ClientRectangle": "0,20.8,9.2,2.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1[\"ExtrasNewInchFlap\"] == DBNull.Value}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text429", "Guid": "d2f510605f2c9e6a9b431bdf5481230a", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.1,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text430", "Guid": "9944cdfca7308dc56fad8ec7ecf162ee", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.89,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Fabric} {IIF(DataSource1.newcolourlisttext == \"0\",\"\",DataSource1.newcolourlisttext)} " }, "CanBreak": true, "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text431", "Guid": "83eafab408379f97172b0a8ca02aad70", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.7,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.companyName}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text432", "Guid": "b060b8eb14e653334f717cf12bd2e821", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "3 inch Flap - Color: White" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text433", "Guid": "a25d4b614ed761a94594d39db4d6a8ca", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Room" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text434", "Guid": "5c4203a10686d1967375e408788a4de9", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,0.7,3.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Locations}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text435", "Guid": "4bd50c575880fb78f53628f47414bced", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "5,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{LineThrough} of {Count()}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text436", "Guid": "095fbaa2532b0e06b3eee93e175adf63", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,1.3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text437", "Guid": "c39d3647ee9edeee5e0090da9b7d1dbe", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.3,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Size" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text438", "Guid": "0d0a383eaed0bc0e61e07e5d10efe391", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.89,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "CanBreak": true, "HorAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text439", "Guid": "d80f321aa50905ffe30ed41de14f127c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.3,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.ControlSide ==\"Left\",\"CL\",IIF(DataSource1.ControlSide ==\"Right\",\"CR\",DataSource1.ControlSide))}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" } }, "MinHeight": 2.6, "MaxHeight": 2.6 }, "9": { "Ident": "StiChildBand", "Name": "ChildBand1", "ClientRectangle": "0,24.2,9.2,2.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1[\"ExtrasNewFreeFormFascia\"] == DBNull.Value}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text440", "Guid": "55c4af15c5475896c51dc57a37ac8dc0", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.1,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text441", "Guid": "5145842679d7ceb61ab174265138bd05", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.89,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Fabric} {IIF(DataSource1.newcolourlisttext == \"0\",\"\",DataSource1.newcolourlisttext)} " }, "CanBreak": true, "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text442", "Guid": "a0834eb72472d7b5fa5a8121e2eadad4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,0.7,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.companyName}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text443", "Guid": "d81655596837746f9f21ac67fe1aea72", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,6.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Free Form Fascia - Color: Clear Anodized" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text444", "Guid": "97ac74d0f8dedb93c03238895faa5540", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Room" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text445", "Guid": "6a6416bac575152b08f731f13b9a0c22", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,0.7,3.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Locations}" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text446", "Guid": "c6649fb3e1394c1b6da2fd5e89f54da3", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "5,0.7,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{LineThrough} of {Count()}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text447", "Guid": "925d875349387281fdabe150dd8c4bbe", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.2,1.3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "CanBreak": true, "Font": "Times New Roman;12;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text448", "Guid": "c9b674a06bac62ba9ca385084332b965", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.3,1.2,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Size" }, "CanBreak": true, "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text449", "Guid": "6abd0a0449c84904b0d6c776541f1b77", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.89,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "CanBreak": true, "HorAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text450", "Guid": "6c77e4074b0be20a6d9b0d36949a700b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.2,1.3,3,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.ControlSide ==\"Left\",\"CL\",IIF(DataSource1.ControlSide ==\"Right\",\"CR\",DataSource1.ControlSide))}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Times New Roman;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:SaddleBrown", "Type": "Expression" } }, "MinHeight": 2.6, "MaxHeight": 2.6 } }, "RightToLeft": true, "ColumnGaps": 1.6, "ColumnWidth": 9.2, "Columns": 2, "UnlimitedBreakable": false, "PageWidth": 21.0, "PageHeight": 28.0, "Watermark": { "Font": "Times New Roman;10;;", "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 0.5, "Right": 0.5, "Top": 0.7, "Bottom": 0.0 } } } }