{ "ReportVersion": "2019.4.2.0", "ReportGuid": "2c1a2d015a7a4ff3b8a0a4f3f86bdc1f", "ReportName": "Report", "ReportAlias": "Report", "ReportCreated": "/Date(1540535962000+0200)/", "ReportChanged": "/Date(1575457831192+0100)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "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": "1", "Name": "parSelectShop", "DialogInfo": { "ItemsInitializationType": "Columns", "KeysColumn": "DSShopSelect.shopid", "ValuesColumn": "DSShopSelect.shopname", "AllowUserValues": false }, "Alias": "parSelectShop", "Type": "System.Int32", "RequestFromUser": true, "Description": "parSelectShop" } }, "DataSources": { "0": { "Ident": "StiMySqlSource", "Name": "DSShopSelect", "Alias": "DSShopSelect", "Key": "610f0b565ad545a3a84f54f689c3b74f", "Columns": { "0": { "Name": "shopid", "Index": -1, "NameInSource": "shopid", "Alias": "shopid", "Type": "System.Int32" }, "1": { "Name": "shopname", "Index": -1, "NameInSource": "shopname", "Alias": "shopname", "Type": "System.String" } }, "NameInSource": "stimultestdb", "SqlCommand": "Select shopid, shopname from shop" }, "1": { "Ident": "StiMySqlSource", "Name": "shop", "Alias": "shop", "Key": "c5cd0c550cf649ce89796a1d119a7187", "Columns": { "0": { "Name": "shopid", "Index": -1, "NameInSource": "shopid", "Alias": "shopid", "Type": "System.Int32" }, "1": { "Name": "shopname", "Index": -1, "NameInSource": "shopname", "Alias": "shopname", "Type": "System.String" } }, "NameInSource": "stimultestdb", "SqlCommand": "select shopid, shopname from shop where shopid={parSelectShop}" }, "2": { "Ident": "StiMySqlSource", "Name": "customer", "Alias": "customer", "Key": "ead4c69e6b364358b1171f2bccb62f3a", "Columns": { "0": { "Name": "customerid", "Index": -1, "NameInSource": "customerid", "Alias": "customerid", "Type": "System.Int32" }, "1": { "Name": "customername", "Index": -1, "NameInSource": "customername", "Alias": "customername", "Type": "System.String" } }, "NameInSource": "stimultestdb", "SqlCommand": "select * from customer" }, "3": { "Ident": "StiMySqlSource", "Name": "salespercustomer", "Alias": "salespercustomer", "Key": "c6f72aef8fb1476199256e2ed139469b", "Columns": { "0": { "Name": "customerid", "Index": -1, "NameInSource": "customerid", "Alias": "customerid", "Type": "System.Int32" }, "1": { "Name": "quantitysold", "Index": -1, "NameInSource": "quantitysold", "Alias": "quantitysold", "Type": "System.Int32" }, "2": { "Name": "salespercustomer_id", "Index": -1, "NameInSource": "salespercustomer_id", "Alias": "salespercustomer_id", "Type": "System.Int32" }, "3": { "Name": "shopid", "Index": -1, "NameInSource": "shopid", "Alias": "shopid", "Type": "System.Int32" } }, "NameInSource": "stimultestdb", "SqlCommand": "select * from salespercustomer " } }, "Databases": { "0": { "Ident": "StiMySqlDatabase", "Name": "stimultestdb", "Alias": "stimultestdb", "ConnectionStringEncrypted": "49DXCe9cAR1gXCn85xhlXotq2S1mXdOFaVqh2MpE617GWmUJyUyIhWtdnNhhBHcjxGz7SE9MS93hQbmEagT2P5BU0QvGVA==" } }, "Relations": { "0": { "Name": "relshopcutsales", "ChildColumns": { "0": "shopid" }, "ParentColumns": { "0": "shopid" }, "NameInSource": "Relation", "Alias": "relshopcutsales", "ParentSource": "shop", "ChildSource": "salespercustomer" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "58a46510fadb77ed0a1043fcd3c46fb1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiHeaderBand", "Name": "Headershop", "ClientRectangle": "0,0.4,19.01,0.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Headershop_shopid", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,9.6,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "shopid" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "1": { "Ident": "StiText", "Name": "Headershop_shopname", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9.6,0,9.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "shopname" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } } } }, "1": { "Ident": "StiDataBand", "Name": "Datashop", "ClientRectangle": "0,2,19.01,0.8", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Datashop_shopid", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,9.6,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{shop.shopid}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "1": { "Ident": "StiText", "Name": "Datashop_shopname", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9.6,0,9.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{shop.shopname}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } } }, "DataSourceName": "shop" }, "2": { "Ident": "StiHeaderBand", "Name": "Headersalespercustomer", "ClientRectangle": "0,3.6,19.01,0.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Headersalespercustomer_customerid", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,4.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "customerid" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "1": { "Ident": "StiText", "Name": "Headersalespercustomer_quantitysold", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.8,0,4.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "quantitysold" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "2": { "Ident": "StiText", "Name": "Headersalespercustomer_salespercustomer_id", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9.6,0,4.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "salespercustomer_id" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "3": { "Ident": "StiText", "Name": "Headersalespercustomer_shopid", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14.4,0,4.6,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "shopid" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } } } }, "3": { "Ident": "StiDataBand", "Name": "Datasalespercustomer", "ClientRectangle": "0,5.2,19.01,0.8", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Datasalespercustomer_customerid", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,4.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{salespercustomer.customerid}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "1": { "Ident": "StiText", "Name": "Datasalespercustomer_quantitysold", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.8,0,4.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{salespercustomer.quantitysold}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "2": { "Ident": "StiText", "Name": "Datasalespercustomer_salespercustomer_id", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9.6,0,4.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{salespercustomer.salespercustomer_id}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "3": { "Ident": "StiText", "Name": "Datasalespercustomer_shopid", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14.4,0,4.6,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{salespercustomer.shopid}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } } }, "DataSourceName": "salespercustomer", "DataRelationName": "Relation", "MasterComponent": "Datashop" } }, "PageWidth": 21.01, "PageHeight": 29.69, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1.0, "Right": 1.0, "Top": 1.0, "Bottom": 1.0 } } } }