{ "ReportVersion": "2019.4.1", "ReportGuid": "ef03b19764f39832ea4bac065d708bb0", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "CrossTab Price Table Report.mrt", "ReportCreated": "/Date(131400000+0530)/", "ReportChanged": "/Date(1644029299000+0530)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "PreviewSettings": 268435455, "Styles": { "0": { "Ident": "StiStyle", "Name": "Style1", "Border": ";;;;;;;solid:Black", "Brush": "solid:PapayaWhip", "TextBrush": "solid:Black", "NegativeTextBrush": "solid:Red" } }, "Dictionary": { "Variables": { "0": { "Value": "1", "Name": "pricetabel", "DialogInfo": { "DateTimeType": "DateAndTime", "ItemsInitializationType": "Columns", "KeysColumn": "DataSource2.pricebookid", "ValuesColumn": "DataSource2.bookname", "AllowUserValues": false }, "Alias": "Price Table Name", "Type": "Stimulsoft.Report.IntList", "RequestFromUser": true }, "1": { "Value": "(pricetabel.Count == 0 ? \"(' ')\" : \"(\" + pricetabel.ToQueryString(\"'\") + \")\")", "Name": "pricetabel1", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "pricetabel1", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "2": { "Value": "1", "Name": "customertype", "DialogInfo": { "AllowUserValues": false, "Keys": { "0": "1", "1": "2", "2": "3" }, "Values": { "0": "Domestic", "1": "Contract", "2": "Trade" } }, "Alias": "Customer Type", "Type": "System.Int32", "RequestFromUser": true }, "3": { "Name": "Asname", "DialogInfo": { "Keys": { "0": "As Net", "1": "As Gross", "2": "As Net Rounded", "3": "As Gross Rounded" }, "Values": { "0": "As Net", "1": "As Gross", "2": "As Net Rounded", "3": "As Gross Rounded" } }, "Alias": "Display Price Table", "Type": "System.String", "RequestFromUser": true } }, "DataSources": { "0": { "Ident": "StiMySqlSource", "Name": "DataSource1", "Alias": "DataSource1", "Key": "aa807c2467cf4836913bd463b3a3a509", "Columns": { "0": { "Name": "width", "Index": -1, "NameInSource": "width", "Alias": "width", "Type": "System.Decimal" }, "1": { "Name": "drop1", "Index": -1, "NameInSource": "drop1", "Alias": "drop1", "Type": "System.Decimal" }, "2": { "Name": "inchwidth", "Index": -1, "NameInSource": "inchwidth", "Alias": "inchwidth", "Type": "System.Decimal" }, "3": { "Name": "inchdrop", "Index": -1, "NameInSource": "inchdrop", "Alias": "inchdrop", "Type": "System.Decimal" }, "4": { "Name": "price", "Index": -1, "NameInSource": "price", "Alias": "price", "Type": "System.Decimal" }, "5": { "Name": "pricebookid", "Index": -1, "NameInSource": "pricebookid", "Alias": "pricebookid", "Type": "System.UInt32" }, "6": { "Name": "bookname", "Index": -1, "NameInSource": "bookname", "Alias": "bookname", "Type": "System.String" }, "7": { "Name": "custType", "Index": -1, "NameInSource": "custType", "Alias": "custType", "Type": "System.Int32" }, "8": { "Name": "domesticmarkup", "Index": -1, "NameInSource": "domesticmarkup", "Alias": "domesticmarkup", "Type": "System.Decimal" }, "9": { "Name": "contractmarkup", "Index": -1, "NameInSource": "contractmarkup", "Alias": "contractmarkup", "Type": "System.Decimal" }, "10": { "Name": "trademarkup", "Index": -1, "NameInSource": "trademarkup", "Alias": "trademarkup", "Type": "System.Decimal" }, "11": { "Name": "pricestructure", "Index": -1, "NameInSource": "pricestructure", "Alias": "pricestructure", "Type": "System.Int32" }, "12": { "Name": "vatrate", "Index": -1, "NameInSource": "vatrate", "Alias": "vatrate", "Type": "System.Decimal" }, "13": { "Name": "Ccountry", "Index": -1, "NameInSource": "Ccountry", "Alias": "Ccountry", "Type": "System.String" }, "14": { "Name": "currency_symbol", "Index": -1, "NameInSource": "currency_symbol", "Alias": "currency_symbol", "Type": "System.String" }, "15": { "Name": "Priceold", "Index": -1, "NameInSource": "Priceold", "Alias": "Priceold", "Type": "System.Int32", "Ident": "Calc", "Expression": "Round(IIF(DataSource1.pricestructure==\"1\",System.Convert.ToDouble(DataSource1.price),IIF(customertype==\"1\",IIF(DataSource1.domesticmarkup>0,System.Convert.ToDouble(DataSource1.price)*DataSource1.domesticmarkup,System.Convert.ToDouble(DataSource1.price)),IIF(customertype==\"3\",IIF(System.Convert.ToDouble(DataSource1.trademarkup)>0,System.Convert.ToDouble(DataSource1.price)*DataSource1.trademarkup,System.Convert.ToDouble(DataSource1.price)),IIF(System.Convert.ToDouble(DataSource1.contractmarkup)>0,System.Convert.ToDouble(DataSource1.price)*DataSource1.contractmarkup,System.Convert.ToDouble(DataSource1.price))))),2)" } }, "NameInSource": "Payment", "SqlCommand": "SELECT\r\nif(vtiger_pricebook.blindscurtains='4',softMax_CurtainsPriceTable.width, if(vtiger_pricebook.pricestructure='2',softmax_SupplierTradePriceTable.width,softMax_ProductsPriceTable.width)) As width,\r\n\r\nif(vtiger_pricebook.blindscurtains='4',softMax_CurtainsPriceTable.drop,\r\nif(vtiger_pricebook.pricestructure='2',softmax_SupplierTradePriceTable.drop,softMax_ProductsPriceTable.drop)) As drop1,\r\n\r\nif(vtiger_pricebook.blindscurtains='4',Round((softMax_CurtainsPriceTable.width/25.4),0),\r\nif(vtiger_pricebook.pricestructure='2',round((softmax_SupplierTradePriceTable.width/25.4),2),Round((softMax_ProductsPriceTable.width/25.4),0))) As inchwidth,\r\n\r\nif(vtiger_pricebook.blindscurtains='4',Round((softMax_CurtainsPriceTable.drop/25.4),0),\r\nif(vtiger_pricebook.pricestructure='2',round((softmax_SupplierTradePriceTable.drop/25.4),2),Round((softMax_ProductsPriceTable.drop/25.4),0))) As inchdrop,\r\n\r\nif(vtiger_pricebook.blindscurtains='4',(softMax_CurtainsPriceTable.price-((softMax_CurtainsPriceTable.price*COALESCE(softMax_CurtainsPriceMap.supplierdiscount,0))/100)),if(vtiger_pricebook.pricestructure='2',(softmax_SupplierTradePriceTable.price-((softmax_SupplierTradePriceTable.price*COALESCE(softMax_ProductPriceMap.supplierdiscount ,0))/100)),(softMax_ProductsPriceTable.price-((softMax_ProductsPriceTable.price*COALESCE(softMax_ProductPriceMap.supplierdiscount,0))/100)))) As price,\r\n\r\nsoftmax_SupplierTradePriceTable.pricebookid,\r\nvtiger_pricebook.bookname,\r\nsoftMax_ProductsPriceTable.custType,\r\nvtiger_pricebook.domesticmarkup,\r\nvtiger_pricebook.contractmarkup,\r\nvtiger_pricebook.trademarkup,\r\nvtiger_pricebook.pricestructure,\r\nvtiger_organizationdetails.vatrate,\r\nvtiger_organizationdetails.country As Ccountry,\r\nvtiger_currency_info.currency_symbol\r\nFROM\r\nvtiger_pricebook\r\nleft join softMax_ProductPriceMap ON softMax_ProductPriceMap.pricebookid=vtiger_pricebook.pricebookid\r\nleft join softMax_CurtainsPriceTable ON softMax_CurtainsPriceTable.pricebookid=vtiger_pricebook.pricebookid\r\nLEFT JOIN softMax_CurtainsPriceMap ON softMax_CurtainsPriceMap.pricebookid=vtiger_pricebook.pricebookid\r\nleft Join softmax_SupplierTradePriceTable ON softmax_SupplierTradePriceTable.Pricebookid = vtiger_pricebook.pricebookid\r\nleft Join softMax_ProductsPriceTable ON softMax_ProductsPriceTable.Pricebookid = vtiger_pricebook.pricebookid,\r\nvtiger_organizationdetails\r\nLEFT JOIN vtiger_currency_info ON vtiger_organizationdetails.countryid = vtiger_currency_info.currency_id\r\n\r\nWHERE vtiger_pricebook.pricebookid IN {pricetabel1} AND (CASE WHEN vtiger_pricebook.pricestructure='1' THEN softMax_ProductsPriceTable.custType = {customertype} when vtiger_pricebook.blindscurtains='4' THEN vtiger_pricebook.blindscurtains='4' ELSE vtiger_pricebook.pricestructure='2' END) AND (softMax_CurtainsPriceMap.status=0 or softMax_ProductPriceMap.status=0 )" }, "1": { "Ident": "StiMySqlSource", "Name": "DataSource2", "Alias": "DataSource2", "Key": "8a51183a49164ad182e2fdacba5667a9", "Columns": { "0": { "Name": "pricebookid", "Index": -1, "NameInSource": "pricebookid", "Alias": "pricebookid", "Type": "System.Int32" }, "1": { "Name": "bookname", "Index": -1, "NameInSource": "bookname", "Alias": "bookname", "Type": "System.String" } }, "NameInSource": "Payment", "SqlCommand": "SELECT \r\nvtiger_pricebook.pricebookid, \r\nvtiger_pricebook.bookname\r\nFROM vtiger_pricebook\r\ninner join softMax_ProductPriceMap ON softMax_ProductPriceMap.pricebookid=vtiger_pricebook.pricebookid\r\ninner join vtiger_products on vtiger_products.productid = softMax_ProductPriceMap.productid\r\nINNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_products.productid\r\nWHERE vtiger_crmentity.deleted = '0' and softMax_ProductPriceMap.status=0 AND vtiger_pricebook.bookname <> ''\r\nORDER BY vtiger_pricebook.bookname" } }, "Databases": { "0": { "Ident": "StiMySqlDatabase", "Name": "Payment", "Alias": "Payment", "ConnectionStringEncrypted": "41b1a2JZe5nLRyml5Vx1Y4s6aSthWQGZYk39xOJ44DvC1NEPSFcxzWBapZjpPWVj31b1o0hQWs1GW/2RZD0=" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page2", "Guid": "26236317c74e34c5407874924c80814b", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand1", "ClientRectangle": "0,0.4,49,0", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Condition": { "Value": "{DataSource1.pricebookid}" } }, "1": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,1.2,49,0", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "DataSourceName": "DataSource1" }, "2": { "Ident": "StiGroupFooterBand", "Name": "GroupFooterBand1", "ClientRectangle": "0,2,49,16.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiCrossTab", "Name": "CrossTab1", "ClientRectangle": "0,0,49,16.6", "Interaction": { "Ident": "StiInteraction" }, "CanBreak": true, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiCrossColumnTotal", "Name": "CrossTab1_ColTotal1", "Guid": "1359ed067d7b3aeee97e9c4ba31c9971", "ClientRectangle": "4.05,0.45,0,0.8", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Enabled": false, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total" }, "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:85,209,255", "TextBrush": "solid:Black" }, "1": { "Ident": "StiCrossColumnTotal", "Name": "CrossTab1_ColTotal2", "Guid": "76b6bc559057ba79e87cc01dc2673ddd", "ClientRectangle": "3.25,0.85,0,0.4", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Enabled": false, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total" }, "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:85,209,255", "TextBrush": "solid:Black" }, "2": { "Ident": "StiCrossRowTotal", "Name": "CrossTab1_RowTotal1", "Guid": "5a85e9b62c62ff551f4756a231dbd118", "ClientRectangle": "0,1.7,2.8,0", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Enabled": false, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total" }, "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:85,209,255", "TextBrush": "solid:Black", "MergeHeaders": false }, "3": { "Ident": "StiCrossTitle", "Name": "CrossTab1_Row1_Title", "Guid": "a9923d3276821c1446ec9792c4ddd0a3", "ClientRectangle": "0,0.45,1.2,0.8", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Drop" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:35,159,217", "TextBrush": "solid:0,9,67", "TypeOfComponent": "Row:CrossTab1_Row1" }, "4": { "Ident": "StiCrossTitle", "Name": "CrossTab1_LeftTitle", "Guid": "af2e768a8f2464386057eb6492b83c9b", "ClientRectangle": "0,0,2.8,0.4", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Price Table Name" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:35,159,217", "TextBrush": "solid:255,255,255", "TypeOfComponent": "LeftTitle" }, "5": { "Ident": "StiCrossRowTotal", "Name": "CrossTab1_RowTotal2", "Guid": "613a2711fdf6674c52fdb630327e09db", "ClientRectangle": "1.2,1.7,0,0", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Enabled": false, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total" }, "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:85,209,255", "TextBrush": "solid:Black" }, "6": { "Ident": "StiCrossTitle", "Name": "CrossTab1_Row2_Title", "Guid": "1417828d931cafe75125fc2e1e5641a8", "ClientRectangle": "1.2,0.45,1.6,0.8", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Inches" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:35,159,217", "TextBrush": "solid:0,9,67", "TypeOfComponent": "Row:CrossTab1_Row2" }, "7": { "Ident": "StiCrossTitle", "Name": "CrossTab1_RightTitle", "Guid": "2c73b94ef5e8af97683a0057ad35847d", "ClientRectangle": "2.85,0,4.2,0.4", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.bookname}" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:35,159,217", "TextBrush": "solid:255,255,255", "TypeOfComponent": "RightTitle" }, "8": { "Ident": "StiCrossRow", "Name": "CrossTab1_Row1", "Guid": "d092a06daf801a66d97a03bf64e26739", "ClientRectangle": "0,1.3,1.2,0.4", "Alias": "drop1", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiCrossHeaderInteraction" }, "Text": { "Value": "drop1" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:35,159,217", "TextBrush": "solid:0,9,67", "Value": { "Value": "{DataSource1.drop1}" }, "DisplayValue": { "Value": "{DataSource1.drop1} mm" }, "TotalGuid": "5a85e9b62c62ff551f4756a231dbd118", "SortDirection": "None", "SortType": "ByValue" }, "9": { "Ident": "StiCrossRow", "Name": "CrossTab1_Row2", "Guid": "b74266cc90f170b8d7d4974f38493809", "ClientRectangle": "1.2,1.3,1.6,0.4", "Alias": "inchdrop", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiCrossHeaderInteraction" }, "Text": { "Value": "inchdrop" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:35,159,217", "TextBrush": "solid:0,9,67", "Value": { "Value": "{DataSource1.inchdrop}" }, "DisplayValue": { "Value": "{DataSource1.inchdrop} inch" }, "TotalGuid": "613a2711fdf6674c52fdb630327e09db", "SortDirection": "None" }, "10": { "Ident": "StiCrossColumn", "Name": "CrossTab1_Column1", "Guid": "44c059654084cb1b93ea45bb64b414e0", "ClientRectangle": "2.85,0.45,4.2,0.4", "Alias": "width", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiCrossHeaderInteraction" }, "Text": { "Value": "width" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:35,159,217", "TextBrush": "solid:0,9,67", "Value": { "Value": "{DataSource1.width}" }, "DisplayValue": { "Value": "{DataSource1.width} mm" }, "TotalGuid": "1359ed067d7b3aeee97e9c4ba31c9971", "SortDirection": "None", "SortType": "ByValue" }, "11": { "Ident": "StiCrossColumn", "Name": "CrossTab1_Column2", "Guid": "81871f9e0dad32da9ca0fb2c6e66fb95", "ClientRectangle": "2.85,0.85,4.2,0.4", "Alias": "inchwidth", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiCrossHeaderInteraction" }, "Text": { "Value": "inchwidth" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:35,159,217", "TextBrush": "solid:0,9,67", "Value": { "Value": "{DataSource1.inchwidth}" }, "DisplayValue": { "Value": "{DataSource1.inchwidth} inch" }, "TotalGuid": "76b6bc559057ba79e87cc01dc2673ddd", "SortDirection": "None" }, "12": { "Ident": "StiCrossSummary", "Name": "CrossTab1_Sum1", "Guid": "6b75390a2c37fc455ab402985d0b429b", "ClientRectangle": "2.85,1.3,4.2,0.4", "Alias": "Priceold", "Restrictions": "AllowMove, AllowResize, AllowSelect, AllowChange", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "0" }, "Font": ";9;;", "Border": "All;0,59,117;;;;;;solid:Black", "Brush": "solid:135,255,255", "TextBrush": "solid:Black", "Value": { "Value": "{IIF(Asname==\"As Net Rounded\",Round(DataSource1.Priceold,0),IIF(Asname==\"As Gross\",Format(\"{0:###0.00}\",DataSource1.Priceold +(DataSource1.Priceold*DataSource1.vatrate)/100),IIF(Asname==\"As Gross Rounded\",Round((Round(DataSource1.Priceold ,2)+Round((DataSource1.Priceold*DataSource1.vatrate)/100,2)),0),Format(\"{0:###0.00}\",DataSource1.Priceold))))}" }, "Summary": "None" } }, "DataSourceName": "DataSource1", "CrossTabStyleIndex": 15, "Wrap": true } } } }, "Orientation": "Landscape", "PageWidth": 50, "PageHeight": 21, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 0.5, "Right": 0.5, "Top": 1, "Bottom": 1 } } } }