{ "ReportVersion": "2020.1.1", "ReportGuid": "38b7a0afc43928dfc617295d9cef14ba", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "Sales-by-Categories.mrt", "ReportCreated": "/Date(1562558404000+0200)/", "ReportChanged": "/Date(1562558404000+0200)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "PreviewSettings": 268435455, "Dictionary": { "Resources": { "0": { "Name": "sales-by-categories-data-source", "Alias": "sales-by-categories-data-source", "Type": "Json", "Image": "by+m3M5CRfcN1Ar5LF5IWrzwAq8sBcaynQfam0ejt+i0tW/AElkffnmWzqufSUmjpo7G7B6RMiYUFv9pnlWEIB2wq/MyYfEjIr1Ho0e0l/8xeZphdB6hKDovvc70DoztvwomIiMQRVRF7P3dacs4F/0/4wJ3tYhvirCd+1N0sdtCBLwgU5JLq7mm4JhwTSjpbNRFBrQsJ42I3RAU8Z7vRYOKZdkC1xIHQHG5CkWjBPPoY1IJGwLe3WXTO4BXAEMSOqjHGKlZMtAX+NVyAXFZUWiE5Pcv/+UxO9lNw/TVf1DV1NYSG/YDjT28+/QtfJQZr3LpENojgFdsvCwsrbihAEtCJvBd2tJ4W+x5pAVsY8lhTCznDKUhle+mT00oO1j5dIfp5CKwOkas9AlfnHfzoNVKC04eNhFBqQ8mssDfVZ1hvZthixhY6Qsh9gPSgY7QiCnKXWBqgOXPv8X6VeYMk3QEn25mwdIKNHkHyri3vYNiqkv3fnzUX2yChgwnGu8TCT5/QIGADnih+04l9xVzrbwvL2Uib1CtXJ229qWPM4P+mjp8XSY908utIUGrmvNbceJXVuj9QxILNMoqV4w7t4Ihl/yM9qtpgtmddqB/Klhx6j+EaY6Fgi+rmWvoLfUhAYh2kEbtiZEfZREAj8C5puAi0W6z4Pd8yc9T/a3Qio+Gepnw5GEysOaMF5s402dok92IeR3cAPc+iDMUO1MST4YSA5Cdca6bIsy4UvwpkFs1o18vn5TVxCLucswCILQ5H8BA1aX2oHVHQe2SwjoapghVXCOHyfi9/YIiF8Dh5DpmAHphYdmyyqbZw6jILVpuhEhtieiRVddzc1tLhjh+VA6mwlh4xE1RwKe5G5MoqBVRgt7lV0LbH4xGp/FR2CkpAj+95WsPKL5SldWPnQVNAbgVr0XDfXNC+M6iZJD1a6WWnTlV0hyskenqO3VCzqJPj9AMDBv/zKmFpapl976a/W0BB4lpUQ1ritB6srts/FZgxEnCC43bzYYR66bRnwPsHNtlRn6MyQM352uiS8UoSAtUnD2xi4ro4XdLge4m26RcZ2b6mh/ZitIKVy3Yb1Lj8K7WR39GvIFH3S3XBZQfV1w1MUK/OVfJiDmcm84VXWbuFzC5Jj0aRjjZBZj8N6jHRTMMVvVcZN6QZB6gQjqbFfVZKT9HTTHPy4Pr2NoP00h0U1U4/40P8uxPFeKP0+wO0aoZQ3/hc7QgxLIWTQG3sajJ//czhciflGArOhS/GxRzyQigxCyeySvuohniL74wO59xuO7inlLU+tmtEEsfkJKlXuujbUPyzsW6z37h6+lHhactKRdO5j13Dm/e+SlX7EH65N36SZfnwHpZRuh4sEtFT8xJp0zC1hN9UPsOXoDh7xfy/nDSOvj76M9+IL59T8ayoW7e+1qzveU3mDZq7gN1GIXjXO56FiwnL1enfE31WXdF6vf1+IeOsAjRuGHMohq9/7ANdNs0kQmYX5siFxtl2ckKv30od54kbQ+mwj8TmbMWN5ugppQhtLdKy9WDvP2UUNcaPKuzGMzKv4jvvcCyMvUCzv6ojGjI3swMjoLnSIU7cxuyjhr5LLu4+08aa0WxJLt+rHUkqKe34cGF6mVxhxtr1yQoAYN/cLXZxaHyKEbwL+IsxfveO+7r6HI71yAM32wrQJG2Wkco3FBZACtUl7/y8Hk8kTlhCrPl2tCJgbWksw8AyLt+BHL1ehXyoNphr9ueqtaqapxmdm9RoTSdHHk6C4hXzboAxZwJDsj6r/CF7ZqIBhs6WxBN/g7JJC7qlTn+83P/2aNwvS1USVFBaOeowL6qlPn3GmE3g+ZyqeG12nlIKllYKKk6gTKFZVvbct5VPinxiIIif9YxE6uCw6lT5ZwlAk4N3dpCUu9gcMuiqZKFqcu+UyWbhrvSnVZ9iB5EpI2CBJYesZDKzfYUM1NoNq/dsFbL7/IJKJolyTt6Fu4eYPF/3cj+6g+u/pAKk2HXfHIodI4pJ+0OH5Zh340vpA==" } }, "Variables": { "0": { "Value": "13:39:51", "Name": "localTime", "Alias": "13:39:51", "Type": "System.String", "Description": "Local Time" }, "1": { "Value": "5.11.2020", "Name": "localDate", "Alias": "5.11.2020", "Type": "System.String", "Description": "Local date" }, "2": { "Value": "\"Sales Report by Categories\"", "Name": "txtSalesReportByCategories", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtSalesReportByCategories", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "3": { "Value": "\"Period \"+ ReportParameters.FromDate.ToString(\"dd.MM.yyyy\") + \" - \" + ReportParameters.ToDate.ToString(\"dd.MM.yyyy\")", "Name": "txtPeriodDetails", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtPeriodDetails", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "4": { "Value": "\"Total\"", "Name": "txtTotal", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtTotal", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "5": { "Value": "\"Sales/categories\"", "Name": "txtSalesPerCategories", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtSalesPerCategories", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "6": { "Value": "\"No.\"", "Name": "txtNo", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtNo", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "7": { "Value": "\"Category\"", "Name": "txtCategory", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtCategory", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "8": { "Value": "\"Count\"", "Name": "txtCount", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtCount", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "9": { "Value": "\"Quantity\"", "Name": "txtQuantity", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtQuantity", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "10": { "Value": "\"Share\"", "Name": "txtShare", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtShare", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "11": { "Value": "\"Unit\"", "Name": "txtUnit", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtUnit", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "12": { "Value": "\"Discount\"", "Name": "txtDiscount", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtDiscount", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "13": { "Value": "\"Turnover (\" + Site.MainCurrencyCode + \")\"", "Name": "txtTurnoverMainCurrency", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtTurnoverMainCurrency", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "14": { "Value": "ReportParameters.FromDate != null ?\r\nReportParameters.FromDate.ToString(\"dd.MM.yyyy HH:mm\") + \" - \" + ReportParameters.ToDate.ToString(\"dd.MM.yyyy HH:mm\") : null", "Name": "paramPeriodDetails", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramPeriodDetails", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "15": { "Value": "ReportParameters_PosNames.Count != 0 ? Func.EngineHelper.JoinColumnContent(ReportParameters_PosNames, \"Name\", \", \") : null", "Name": "paramPosNames", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramPosNames", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "16": { "Value": "ReportParameters_UserNames.Count != 0 ? Func.EngineHelper.JoinColumnContent(ReportParameters_UserNames, \"Name\", \", \") : null", "Name": "paramUserNames", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramUserNames", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "17": { "Value": "\"Pos\"", "Name": "txtPos", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtPos", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "18": { "Value": "\"Cashier\"", "Name": "txtCashier", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtCashier", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "19": { "Value": "\"Period\"", "Name": "txtPeriod", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtPeriod", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "20": { "Value": "\"Site: \" + Site.Name + \", \" + Site.Street + \", \" + Site.PostalCode + \" \" + Site.City + \", \" + Site.Country", "Name": "txtSiteDetails", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtSiteDetails", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "21": { "Value": "\"Product Group\"", "Name": "txtProductGroup", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtProductGroup", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "22": { "Value": "ReportParameters_ProductGroupNames.Count != 0 ? Func.EngineHelper.JoinColumnContent(ReportParameters_ProductGroupNames, \"Name\", \", \") : null", "Name": "paramProductGroupNames", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramProductGroupNames", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "23": { "Value": "ReportParameters.GroupedBy == \"ProductGroup\" ? ProductTotalsEffectOnMargins.ProductGroupNumber : ProductTotalsEffectOnMargins.ProductNumber", "Name": "txtDatasourceNumber", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtDatasourceNumber", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "24": { "Value": "\"Category Level\"", "Name": "txtCategoryLevel", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtCategoryLevel", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "25": { "Value": "ReportParameters.GroupedBy == \"ProductGroup\" ? ProductTotalsEffectOnMargins.ProductGroupName : ProductTotalsEffectOnMargins.ProductName", "Name": "txtDatasourceName", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtDatasourceName", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "26": { "Value": "ReportParameters.FromTime != null ?\r\n((DateTime)ReportParameters.FromTime).ToString(\"HH:mm\") + \" - \" + ((DateTime)ReportParameters.ToTime).ToString(\"HH:mm\") : null", "Name": "paramTimeRange", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramTimeRange", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "27": { "Value": "\"Time range\"", "Name": "txtTimeRange", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtTimeRange", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "28": { "Value": "ReportParameters.FromBookKeepingDate != null ?\r\nReportParameters.FromBookKeepingDate.ToString(\"dd.MM.yyyy\") + \" - \" + ReportParameters.ToBookKeepingDate.ToString(\"dd.MM.yyyy\") : null", "Name": "paramBookKeepingPeriod", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramBookKeepingPeriod", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "29": { "Value": "\"Bookkeeping period\"", "Name": "txtBookKeepingPeriod", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtBookKeepingPeriod", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "30": { "Value": "\"Business unit\"", "Name": "txtBusinessUnit", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtBusinessUnit", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "31": { "Value": "ReportParameters_BusinessUnitNames.Count != 0 ? Func.EngineHelper.JoinColumnContent(ReportParameters_BusinessUnitNames, \"Name\", \", \") : null", "Name": "paramBusinessUnitNames", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramBusinessUnitNames", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "32": { "Value": "\"Product\"", "Name": "txtProduct", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtProduct", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "33": { "Value": "ReportParameters_ProductNames.Count != 0 ? Func.EngineHelper.JoinColumnContent(ReportParameters_ProductNames, \"Name\", \", \") : null", "Name": "paramProductNames", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramProductNames", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "34": { "Value": "\"Gross amount\"", "Name": "txtGrossAmount", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtGrossAmount", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "35": { "Value": "SalesPerCategories.Level", "Name": "varIndentLeft", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "varIndentLeft", "Type": "System.Int32", "ReadOnly": true, "InitBy": "Expression" }, "36": { "Value": "Left(\"XXXXXXXXXXXXXXXXXXXX\",SalesPerCategories.Level)", "Name": "varIndentRight", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "varIndentRight", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "37": { "Value": "ReportParameters_CategoryNames.Count != 0 ? Func.EngineHelper.JoinColumnContent(ReportParameters_CategoryNames, \"Name\", \", \") : null", "Name": "paramCategoryNames", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "paramCategoryNames", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "38": { "Value": "\"Other products\"", "Name": "txtOtherProducts", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtOtherProducts", "Type": "System.String", "InitBy": "Expression" }, "39": { "Value": "\"other\"", "Name": "txtOther", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtOther", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "40": { "Value": "\"Other\"", "Name": "txtOtherUppercase", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "txtOtherUppercase", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" }, "41": { "Value": "Left(\"XXXXXXXXXXXXXXXXXXXX\",varIndentLeft)", "Name": "varIndentLeft2", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "varIndentLeft2", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" } }, "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "ReportParameters", "Alias": "ReportParameters", "Columns": { "0": { "Name": "BusinessUnitNames", "Index": -1, "NameInSource": "BusinessUnitNames", "Alias": "BusinessUnitNames", "Type": "System.String" }, "1": { "Name": "CategoryLevel", "Index": -1, "NameInSource": "CategoryLevel", "Alias": "CategoryLevel", "Type": "System.Decimal" }, "2": { "Name": "CategoryNames", "Index": -1, "NameInSource": "CategoryNames", "Alias": "CategoryNames", "Type": "System.String" }, "3": { "Name": "FromBookKeepingDate", "Index": -1, "NameInSource": "FromBookKeepingDate", "Alias": "FromBookKeepingDate", "Type": "System.DateTime" }, "4": { "Name": "FromDate", "Index": -1, "NameInSource": "FromDate", "Alias": "FromDate", "Type": "System.DateTime" }, "5": { "Name": "FromTime", "Index": -1, "NameInSource": "FromTime", "Alias": "FromTime", "Type": "System.DateTime" }, "6": { "Name": "PosNames", "Index": -1, "NameInSource": "PosNames", "Alias": "PosNames", "Type": "System.String" }, "7": { "Name": "ProductGroupNames", "Index": -1, "NameInSource": "ProductGroupNames", "Alias": "ProductGroupNames", "Type": "System.String" }, "8": { "Name": "ProductNames", "Index": -1, "NameInSource": "ProductNames", "Alias": "ProductNames", "Type": "System.String" }, "9": { "Name": "ToBookKeepingDate", "Index": -1, "NameInSource": "ToBookKeepingDate", "Alias": "ToBookKeepingDate", "Type": "System.DateTime" }, "10": { "Name": "ToDate", "Index": -1, "NameInSource": "ToDate", "Alias": "ToDate", "Type": "System.DateTime" }, "11": { "Name": "ToTime", "Index": -1, "NameInSource": "ToTime", "Alias": "ToTime", "Type": "System.DateTime" }, "12": { "Name": "UserNames", "Index": -1, "NameInSource": "UserNames", "Alias": "UserNames", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.ReportParameters" }, "1": { "Ident": "StiDataTableSource", "Name": "ReportParameters_BusinessUnitNames", "Alias": "ReportParameters_BusinessUnitNames", "Columns": { "0": { "Name": "Name", "Index": -1, "NameInSource": "Name", "Alias": "Name", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.ReportParameters_BusinessUnitNames" }, "2": { "Ident": "StiDataTableSource", "Name": "ReportParameters_CategoryNames", "Alias": "ReportParameters_CategoryNames", "Columns": { "0": { "Name": "Name", "Index": -1, "NameInSource": "Name", "Alias": "Name", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.ReportParameters_CategoryNames" }, "3": { "Ident": "StiDataTableSource", "Name": "ReportParameters_PosNames", "Alias": "ReportParameters_PosNames", "Columns": { "0": { "Name": "Name", "Index": -1, "NameInSource": "Name", "Alias": "Name", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.ReportParameters_PosNames" }, "4": { "Ident": "StiDataTableSource", "Name": "ReportParameters_ProductGroupNames", "Alias": "ReportParameters_ProductGroupNames", "Columns": { "0": { "Name": "Name", "Index": -1, "NameInSource": "Name", "Alias": "Name", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.ReportParameters_ProductGroupNames" }, "5": { "Ident": "StiDataTableSource", "Name": "ReportParameters_ProductNames", "Alias": "ReportParameters_ProductNames", "Columns": { "0": { "Name": "Name", "Index": -1, "NameInSource": "Name", "Alias": "Name", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.ReportParameters_ProductNames" }, "6": { "Ident": "StiDataTableSource", "Name": "ReportParameters_UserNames", "Alias": "ReportParameters_UserNames", "Columns": { "0": { "Name": "Name", "Index": -1, "NameInSource": "Name", "Alias": "Name", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.ReportParameters_UserNames" }, "7": { "Ident": "StiDataTableSource", "Name": "SalesPerCategories", "Alias": "SalesPerCategories", "Columns": { "0": { "Name": "AmountWithDiscounts", "Index": -1, "NameInSource": "AmountWithDiscounts", "Alias": "AmountWithDiscounts", "Type": "System.Decimal" }, "1": { "Name": "AmountWithoutDiscounts", "Index": -1, "NameInSource": "AmountWithoutDiscounts", "Alias": "AmountWithoutDiscounts", "Type": "System.Decimal" }, "2": { "Name": "Count", "Index": -1, "NameInSource": "Count", "Alias": "Count", "Type": "System.Decimal" }, "3": { "Name": "IsDirect", "Index": -1, "NameInSource": "IsDirect", "Alias": "IsDirect", "Type": "System.Boolean" }, "4": { "Name": "Level", "Index": -1, "NameInSource": "Level", "Alias": "Level", "Type": "System.Decimal" }, "5": { "Name": "ParentPath", "Index": -1, "NameInSource": "ParentPath", "Alias": "ParentPath", "Type": "System.String" }, "6": { "Name": "ParentProductCategoryId", "Index": -1, "NameInSource": "ParentProductCategoryId", "Alias": "ParentProductCategoryId", "Type": "System.Decimal" }, "7": { "Name": "Path", "Index": -1, "NameInSource": "Path", "Alias": "Path", "Type": "System.String" }, "8": { "Name": "ProductCategoryId", "Index": -1, "NameInSource": "ProductCategoryId", "Alias": "ProductCategoryId", "Type": "System.Decimal" }, "9": { "Name": "ProductCategoryName", "Index": -1, "NameInSource": "ProductCategoryName", "Alias": "ProductCategoryName", "Type": "System.String" }, "10": { "Name": "Quantity", "Index": -1, "NameInSource": "Quantity", "Alias": "Quantity", "Type": "System.Decimal" }, "11": { "Name": "UnitName", "Index": -1, "NameInSource": "UnitName", "Alias": "UnitName", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.SalesPerCategories" }, "8": { "Ident": "StiDataTableSource", "Name": "Site", "Alias": "Site", "Columns": { "0": { "Name": "City", "Index": -1, "NameInSource": "City", "Alias": "City", "Type": "System.String" }, "1": { "Name": "Country", "Index": -1, "NameInSource": "Country", "Alias": "Country", "Type": "System.String" }, "2": { "Name": "ExternalId", "Index": -1, "NameInSource": "ExternalId", "Alias": "ExternalId", "Type": "System.String" }, "3": { "Name": "Id", "Index": -1, "NameInSource": "Id", "Alias": "Id", "Type": "System.Decimal" }, "4": { "Name": "Logo", "Index": -1, "NameInSource": "Logo", "Alias": "Logo", "Type": "System.String" }, "5": { "Name": "MainCurrencyCode", "Index": -1, "NameInSource": "MainCurrencyCode", "Alias": "MainCurrencyCode", "Type": "System.String" }, "6": { "Name": "MainCurrencyDecimalPlaces", "Index": -1, "NameInSource": "MainCurrencyDecimalPlaces", "Alias": "MainCurrencyDecimalPlaces", "Type": "System.Decimal" }, "7": { "Name": "Name", "Index": -1, "NameInSource": "Name", "Alias": "Name", "Type": "System.String" }, "8": { "Name": "PhoneNumber", "Index": -1, "NameInSource": "PhoneNumber", "Alias": "PhoneNumber", "Type": "System.String" }, "9": { "Name": "PostalCode", "Index": -1, "NameInSource": "PostalCode", "Alias": "PostalCode", "Type": "System.String" }, "10": { "Name": "Street", "Index": -1, "NameInSource": "Street", "Alias": "Street", "Type": "System.String" } }, "NameInSource": "sales-by-categories-data-source.Site" } }, "Databases": { "0": { "Ident": "StiJsonDatabase", "Name": "sales-by-categories-data-source", "Alias": "sales-by-categories-data-source", "PathData": "resource://sales-by-categories-data-source" } }, "Relations": { "0": { "Name": "ReportParameters", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "BusinessUnitNames" }, "NameInSource": "ReportParameters_BusinessUnitNames", "Alias": "ReportParameters", "IsCloud": null, "ParentSource": "ReportParameters", "ChildSource": "ReportParameters_BusinessUnitNames" }, "1": { "Name": "ReportParameters", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "CategoryNames" }, "NameInSource": "ReportParameters_CategoryNames", "Alias": "ReportParameters", "IsCloud": null, "ParentSource": "ReportParameters", "ChildSource": "ReportParameters_CategoryNames" }, "2": { "Name": "ReportParameters", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "PosNames" }, "NameInSource": "ReportParameters_PosNames", "Alias": "ReportParameters", "IsCloud": null, "ParentSource": "ReportParameters", "ChildSource": "ReportParameters_PosNames" }, "3": { "Name": "ReportParameters", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProductGroupNames" }, "NameInSource": "ReportParameters_ProductGroupNames", "Alias": "ReportParameters", "IsCloud": null, "ParentSource": "ReportParameters", "ChildSource": "ReportParameters_ProductGroupNames" }, "4": { "Name": "ReportParameters", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProductNames" }, "NameInSource": "ReportParameters_ProductNames", "Alias": "ReportParameters", "IsCloud": null, "ParentSource": "ReportParameters", "ChildSource": "ReportParameters_ProductNames" }, "5": { "Name": "ReportParameters", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "UserNames" }, "NameInSource": "ReportParameters_UserNames", "Alias": "ReportParameters", "IsCloud": null, "ParentSource": "ReportParameters", "ChildSource": "ReportParameters_UserNames" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "6a33257b93bc1a49471ddb5a535077b3", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiHeaderBand", "Name": "Header_SalesByCategories", "ClientRectangle": "0,0.4,18.01,1.5", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "Guid": "f0bd4d71c3a4492987d25c34a66746ec", "ClientRectangle": "0,0.4,18,0.6", "ComponentStyle": "Test_Header", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtSalesPerCategories}" }, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;10;Bold;", "Border": "Left, Right;117,112,112;;;;;true;solid:0,0,0", "Brush": "solid:68,114,196", "TextBrush": "solid:255,255,255", "Margins": { "Left": 4, "Right": 0, "Top": 0, "Bottom": 0 }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text3", "Guid": "092db43faad8ebf8b1a9b6ec85ba6431", "ClientRectangle": "0,1,5.2,0.4", "ComponentStyle": "Test_Header_ColumnCaptions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtCategory}" }, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": "Left, Right;117,112,112;;;;;true;solid:0,0,0", "Brush": "solid:40,135,200", "TextBrush": "solid:255,255,255", "TextQuality": "Wysiwyg", "Margins": { "Left": 2, "Right": 0, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text5", "Guid": "6e39432689f1c2117bf24407125552fe", "ClientRectangle": "5.2,1,1.8,0.4", "ComponentStyle": "Test_Header_ColumnCaptions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtQuantity}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": "Left, Right;117,112,112;;;;;true;solid:0,0,0", "Brush": "solid:40,135,200", "TextBrush": "solid:255,255,255", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text9", "Guid": "3213279fbd0a31468552b44c7c8d7d35", "ClientRectangle": "7,1,1.9,0.4", "ComponentStyle": "Test_Header_ColumnCaptions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtUnit}" }, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": "Left, Right;117,112,112;;;;;true;solid:0,0,0", "Brush": "solid:40,135,200", "TextBrush": "solid:255,255,255", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text10", "Guid": "372a4e74a932e3355587ccf2031f3779", "ClientRectangle": "16.3,1,1.7,0.4", "ComponentStyle": "Test_Header_ColumnCaptions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtShare}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": "Left, Right;117,112,112;;;;;true;solid:0,0,0", "Brush": "solid:40,135,200", "TextBrush": "solid:255,255,255", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text11", "Guid": "16bf38dbba0a1421aa3b12497726ffd0", "ClientRectangle": "8.9,1,2.5,0.4", "ComponentStyle": "Test_Header_ColumnCaptions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtGrossAmount}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": "Left, Right;117,112,112;;;;;true;solid:0,0,0", "Brush": "solid:40,135,200", "TextBrush": "solid:255,255,255", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text12", "Guid": "6c79212dcaaea65064ed8fd878c1b9b8", "ClientRectangle": "11.4,1,2.5,0.4", "ComponentStyle": "Test_Header_ColumnCaptions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtDiscount}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": "Left, Right;117,112,112;;;;;true;solid:0,0,0", "Brush": "solid:40,135,200", "TextBrush": "solid:255,255,255", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text13", "Guid": "2fcaf397251ceb1e0a8c08b85d2d9c32", "ClientRectangle": "13.9,1,2.5,0.4", "ComponentStyle": "Test_Header_ColumnCaptions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtTurnoverMainCurrency}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": "Left, Right;117,112,112;;;;;true;solid:0,0,0", "Brush": "solid:40,135,200", "TextBrush": "solid:255,255,255", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "Expression" }, "8": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive1", "Guid": "b4ee5933f79e22600e74bdeabb26c5eb", "ClientRectangle": "0,1,18,0.0254", "Interaction": { "Ident": "StiInteraction" }, "Color": "255,255,255", "StartCap": ";;;", "EndCap": ";;;" } } }, "1": { "Ident": "StiHierarchicalBand", "Name": "Hierarchy_SalesByCategories", "CanShrink": true, "ClientRectangle": "0,2.7,18.01,1.6", "Linked": true, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiPanel", "Name": "pnlLevelRest", "Guid": "e83ff12f25137dd748c5df82748d9d54", "DockStyle": "Top", "ClientRectangle": "0,0,18.01,0.5", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{SalesPerCategories.Level <= 0}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "txtIndentLeftLevelRest", "ShiftMode": "None", "Guid": "83ff35003521e2864baa3580a504e692", "DockStyle": "Left", "ClientRectangle": "0,0,0.11,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{varIndentLeft2}" }, "AutoWidth": true, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text16", "Guid": "27211167a49b11c13b4dd1af1971ff12", "DockStyle": "Left", "ClientRectangle": "0.11,0,5.1,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.IsDirect == true ? SalesPerCategories.ProductCategoryName + \" (\" + txtOther + \")\" : SalesPerCategories.ProductCategoryName }" }, "AutoWidth": true, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text17", "Guid": "f9a1de21d5fbc8c55967cb397874f2d5", "ClientRectangle": "5.2,0,1.8,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.Quantity}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "txtIndentRightLevelRest", "ShiftMode": "None", "Guid": "f98fca2127c1c1afd83170b27a3b4074", "DockStyle": "Right", "ClientRectangle": "17.9,0,0.11,0.5", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{false}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{varIndentRight}" }, "AutoWidth": true, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "empty", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text22", "Guid": "af808d4c1555f3078edc3a978611a3c4", "DockStyle": "Right", "ClientRectangle": "16.4,0,1.5,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.Count == 0 ? \"0\" : SalesPerCategories.AmountWithDiscounts/Sum(Hierarchy_SalesByCategories,SalesPerCategories.AmountWithDiscounts)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiPercentageFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "PositivePattern": 1, "Symbol": "%" }, "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text19", "Guid": "32f88d63dd247f2ee1ded9c213c09e9c", "ClientRectangle": "7,0,1.9,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.UnitName}" }, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 0, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text18", "Guid": "fe30bde8ffcc289e6dae59009890b6db", "DockStyle": "Right", "ClientRectangle": "13.9,0,2.5,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text20", "Guid": "f1612d0a9ae5eea35f246dc94c216f7f", "DockStyle": "Right", "ClientRectangle": "11.4,0,2.5,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithoutDiscounts-SalesPerCategories.AmountWithDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text21", "Guid": "00d4a4ac9752643a2976354decf083ff", "DockStyle": "Right", "ClientRectangle": "8.9,0,2.5,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithoutDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" } } }, "1": { "Ident": "StiPanel", "Name": "pnlLevel1", "Guid": "c0146e60ecf4085e94e9b43c08da5c00", "DockStyle": "Top", "ClientRectangle": "0,0.5,18.01,0.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{SalesPerCategories.Level != 0}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "txtIndentLeftLevel1", "ShiftMode": "None", "Guid": "69da5f50a5a47a48c0f92a6a01e16151", "DockStyle": "Left", "ClientRectangle": "0,0,0.11,0.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{false}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{varIndentLeft2}" }, "AutoWidth": true, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "empty", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "txtIndentRightLevel1", "ShiftMode": "None", "Guid": "8c737cf4c77d0e0168e84abdd1547645", "DockStyle": "Right", "ClientRectangle": "17.9,0,0.11,0.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{false}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{varIndentRight}" }, "AutoWidth": true, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "empty", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text23", "Guid": "68ce482e883c7bf69b102656e3b86ebb", "DockStyle": "Left", "ClientRectangle": "0.11,0,5.1,0.6", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold_Underlined", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.IsDirect == true ? txtOtherUppercase : SalesPerCategories.ProductCategoryName}" }, "VertAlignment": "Bottom", "Font": "Microsoft Sans Serif;;Bold;", "Border": "Bottom;117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 0, "Top": 0, "Bottom": 3 }, "ShrinkFontToFit": true, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text2", "Guid": "738e92e064bb4eb12bf7723cff26db77", "ClientRectangle": "5.2,0,1.8,0.6", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold_Underlined", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.Quantity}" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Microsoft Sans Serif;;Bold;", "Border": "Bottom;117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 0, "Top": 0, "Bottom": 3 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text14", "Guid": "9636456903e1f443d638e9526d9dc601", "DockStyle": "Right", "ClientRectangle": "16.4,0,1.5,0.6", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold_Underlined", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithDiscounts/Sum(Hierarchy_SalesByCategories,SalesPerCategories.AmountWithDiscounts)}" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Microsoft Sans Serif;;Bold;", "Border": "Bottom;117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 0, "Top": 0, "Bottom": 3 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiPercentageFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "PositivePattern": 1, "Symbol": "%" }, "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text8", "Guid": "d7ea5674e0c98ab1871770b68e3840be", "DockStyle": "Right", "ClientRectangle": "13.9,0,2.5,0.6", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold_Underlined", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Microsoft Sans Serif;;Bold;", "Border": "Bottom;117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 4, "Top": 0, "Bottom": 3 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text6", "Guid": "b0b00056278e09a25031fef26b38e646", "ClientRectangle": "7,0,1.9,0.6", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold_Underlined", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.UnitName}" }, "VertAlignment": "Bottom", "Font": "Microsoft Sans Serif;;Bold;", "Border": "Bottom;117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 0, "Top": 0, "Bottom": 3 }, "ShrinkFontToFit": true, "Type": "DataColumn" }, "7": { "Ident": "StiText", "Name": "Text4", "Guid": "0326bcc0191da76e1c7eb0bf3a2c0ddb", "DockStyle": "Right", "ClientRectangle": "11.4,0,2.5,0.6", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold_Underlined", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithoutDiscounts-SalesPerCategories.AmountWithDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Microsoft Sans Serif;;Bold;", "Border": "Bottom;117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 4, "Top": 0, "Bottom": 3 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text7", "Guid": "a280872b00e44a7fc37157ccf94457ac", "ClientRectangle": "8.9,0,2.5,0.6", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold_Underlined", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithoutDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Microsoft Sans Serif;;Bold;", "Border": "Bottom;117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 0, "Top": 0, "Bottom": 3 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" } } }, "2": { "Ident": "StiPanel", "Name": "pnlLevel0", "DockStyle": "Top", "ClientRectangle": "0,1.1,18.01,0.5", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{SalesPerCategories.Level != -1}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Border": "Bottom;;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "txtIndentLeftLevel0", "ShiftMode": "None", "Guid": "6b3ff6f8475ace8af7013a1f5715aeca", "DockStyle": "Left", "ClientRectangle": "0,0,0.11,0.5", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{false}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{varIndentLeft2}" }, "AutoWidth": true, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "empty", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "txtIndentRightLevel0", "ShiftMode": "None", "Guid": "4e39722b35f8d01169b48b2348a252a7", "DockStyle": "Right", "ClientRectangle": "17.9,0,0.11,0.5", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{false}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{varIndentRight}" }, "AutoWidth": true, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "empty", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text27", "Guid": "1201d2304aeece8dc39d77723f4a302a", "DockStyle": "Right", "ClientRectangle": "16.4,0,1.5,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithDiscounts/Sum(Hierarchy_SalesByCategories,SalesPerCategories.AmountWithDiscounts)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;Bold;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiPercentageFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "PositivePattern": 1, "Symbol": "%" }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text28", "Guid": "cfac6e66b987c93ed1c27507c7664072", "DockStyle": "Right", "ClientRectangle": "13.9,0,2.5,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;Bold;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text29", "Guid": "a106625927cbb36531edcac92901d8a0", "ClientRectangle": "7,0,1.9,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.UnitName}" }, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;Bold;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 4, "Right": 0, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "Type": "DataColumn" }, "5": { "Ident": "StiText", "Name": "Text30", "Guid": "b7eceb1c9c45abb6c222217a83212b01", "DockStyle": "Right", "ClientRectangle": "11.4,0,2.5,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithoutDiscounts-SalesPerCategories.AmountWithDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;Bold;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 0, "Right": 4, "Top": 0, "Bottom": 0 }, "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text24", "Guid": "57eb5af41b285ffa86ef61960f2ba956", "DockStyle": "Left", "ClientRectangle": "0.11,0,5.1,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{txtTotal}" }, "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;Bold;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text25", "Guid": "5b02db224ed2471d1e415e365434bdd1", "ClientRectangle": "5.2,0,1.8,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.Quantity}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;Bold;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "DataColumn" }, "8": { "Ident": "StiText", "Name": "Text31", "Guid": "0cee7976d607d2dbdcec122026755158", "ClientRectangle": "8.9,0,2.5,0.5", "ComponentStyle": "Test_Data_ColumnDetail_Borderless_Bold", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{SalesPerCategories.AmountWithoutDiscounts}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Microsoft Sans Serif;;Bold;", "Border": ";117,112,112;;;;;true;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "ShrinkFontToFit": true, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" } } } }, "DataSourceName": "SalesPerCategories", "EvenStyle": "Test_Data_EvenRow", "KeyDataColumn": "Path", "MasterKeyDataColumn": "ParentPath", "Indent": 0 }, "2": { "Ident": "StiFooterBand", "Name": "Footer_SalesByCategories", "ClientRectangle": "0,5.1,18.01,0", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent" } }, "PageWidth": 21.01, "PageHeight": 30, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 2, "Right": 1, "Top": 1, "Bottom": 1 } } } }