using System; using System.Drawing; using System.Windows.Forms; using System.Data; using Stimulsoft.Controls; using Stimulsoft.Base.Drawing; using Stimulsoft.Report; using Stimulsoft.Report.Dialogs; using Stimulsoft.Report.Components; namespace Reports { public class Report : Stimulsoft.Report.StiReport { public Report() { this.InitializeComponent(); } #region StiReport Designer generated code - do not modify public Stimulsoft.Report.Dictionary.StiDataRelation ParentSuppliers; public Stimulsoft.Report.Dictionary.StiDataRelation ParentCategories; public Stimulsoft.Report.Dictionary.StiDataRelation ParentShippers; public Stimulsoft.Report.Dictionary.StiDataRelation ParentEmployees; public Stimulsoft.Report.Dictionary.StiDataRelation ParentCustomers; public Stimulsoft.Report.Dictionary.StiDataRelation ParentProducts; public Stimulsoft.Report.Dictionary.StiDataRelation ParentOrders; public Stimulsoft.Report.Components.StiPage Page1; public Stimulsoft.Report.Components.Table.StiTable Table1; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell1; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell2; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell3; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell4; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell5; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell6; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell7; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell8; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell9; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell10; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell11; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell12; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell13; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell14; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell15; public Stimulsoft.Report.Components.Table.StiTableCell Table1_Cell16; public Stimulsoft.Report.Components.StiWatermark Page1_Watermark; public Stimulsoft.Report.Print.StiPrinterSettings Report_PrinterSettings; public CategoriesDataSource Categories; public CustomersDataSource Customers; public EmployeesDataSource Employees; public Order_DetailsDataSource Order_Details; public OrdersDataSource Orders; public ProductsDataSource Products; public ShippersDataSource Shippers; public SuppliersDataSource Suppliers; public CountriesDataSource Countries; public new StatesDataSource States; public AutoDataSource Auto; public GlobalGrowthDataSource GlobalGrowth; public OpecDataSource Opec; private void InitializeComponent() { this.Opec = new OpecDataSource(); this.GlobalGrowth = new GlobalGrowthDataSource(); this.Auto = new AutoDataSource(); this.States = new StatesDataSource(); this.Countries = new CountriesDataSource(); this.Suppliers = new SuppliersDataSource(); this.Shippers = new ShippersDataSource(); this.Products = new ProductsDataSource(); this.Orders = new OrdersDataSource(); this.Order_Details = new Order_DetailsDataSource(); this.Employees = new EmployeesDataSource(); this.Customers = new CustomersDataSource(); this.Categories = new CategoriesDataSource(); this.ParentSuppliers = new Stimulsoft.Report.Dictionary.StiDataRelation("SuppliersProducts", "Suppliers", "Suppliers", this.Suppliers, this.Products, new System.String[] { "SupplierID"}, new System.String[] { "SupplierID"}); this.ParentCategories = new Stimulsoft.Report.Dictionary.StiDataRelation("CategoriesProducts", "Categories", "Categories", this.Categories, this.Products, new System.String[] { "CategoryID"}, new System.String[] { "CategoryID"}); this.ParentShippers = new Stimulsoft.Report.Dictionary.StiDataRelation("ShippersOrders", "Shippers", "Shippers", this.Shippers, this.Orders, new System.String[] { "ShipperID"}, new System.String[] { "ShipVia"}); this.ParentEmployees = new Stimulsoft.Report.Dictionary.StiDataRelation("EmployeesOrders", "Employees", "Employees", this.Employees, this.Orders, new System.String[] { "EmployeeID"}, new System.String[] { "EmployeeID"}); this.ParentCustomers = new Stimulsoft.Report.Dictionary.StiDataRelation("CustomersOrders", "Customers", "Customers", this.Customers, this.Orders, new System.String[] { "CustomerID"}, new System.String[] { "CustomerID"}); this.ParentProducts = new Stimulsoft.Report.Dictionary.StiDataRelation("ProductsOrderDetails", "Products", "Products", this.Products, this.Order_Details, new System.String[] { "ProductID"}, new System.String[] { "ProductID"}); this.ParentOrders = new Stimulsoft.Report.Dictionary.StiDataRelation("OrdersOrderDetails", "Orders", "Orders", this.Orders, this.Order_Details, new System.String[] { "OrderID"}, new System.String[] { "OrderID"}); this.NeedsCompiling = false; this.EngineVersion = Stimulsoft.Report.Engine.StiEngineVersion.EngineV2; this.ReferencedAssemblies = new System.String[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll"}; this.ReportAlias = "Report"; // // ReportChanged // this.ReportChanged = new DateTime(2013, 1, 17, 16, 6, 15, 921); // // ReportCreated // this.ReportCreated = new DateTime(2013, 1, 17, 16, 5, 54, 0); this.ReportFile = ""; this.ReportGuid = "5ad5d0fbdb9e45929cc4eaf424bda4c2"; this.ReportName = "Report"; this.ReportUnit = Stimulsoft.Report.StiReportUnitType.Centimeters; this.ReportVersion = "2013.1.1503"; this.ScriptLanguage = Stimulsoft.Report.StiReportLanguageType.CSharp; // // Page1 // this.Page1 = new Stimulsoft.Report.Components.StiPage(); this.Page1.Guid = "8ae19a0f4ed54cbb9eff9512271464e9"; this.Page1.Name = "Page1"; this.Page1.PageHeight = 29.7; this.Page1.PageWidth = 21; this.Page1.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.None, System.Drawing.Color.Black, 2, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black), false); this.Page1.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); // // Table1 // this.Table1 = new Stimulsoft.Report.Components.Table.StiTable(); this.Table1.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(0, 0.4, 19, 3.2); this.Table1.ColumnCount = 4; this.Table1.MinHeight = 0.8; this.Table1.Name = "Table1"; this.Table1.NumberID = 25; this.Table1.RowCount = 4; this.Table1.Sort = new System.String[0]; this.Table1.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.None, System.Drawing.Color.Black, 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black), false); this.Table1.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); // // Table1_Cell1 // this.Table1_Cell1 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell1.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(0, 0, 4.8, 0.8); this.Table1_Cell1.Enabled = false; this.Table1_Cell1.ID = 0; this.Table1_Cell1.JoinCells = new int[0]; this.Table1_Cell1.Name = "Table1_Cell1"; this.Table1_Cell1.ParentJoin = 3; this.Table1_Cell1.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell1.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell1.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell1.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell1.Guid = null; this.Table1_Cell1.Indicator = null; this.Table1_Cell1.Interaction = null; this.Table1_Cell1.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell1.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell1.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell2 // this.Table1_Cell2 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell2.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(4.8, 0, 4.8, 0.8); this.Table1_Cell2.Enabled = false; this.Table1_Cell2.ID = 1; this.Table1_Cell2.JoinCells = new int[0]; this.Table1_Cell2.Name = "Table1_Cell2"; this.Table1_Cell2.ParentJoin = 3; this.Table1_Cell2.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell2.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell2.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell2.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell2.Guid = null; this.Table1_Cell2.Indicator = null; this.Table1_Cell2.Interaction = null; this.Table1_Cell2.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell2.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell2.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell3 // this.Table1_Cell3 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell3.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(9.6, 0, 4.8, 0.8); this.Table1_Cell3.Enabled = false; this.Table1_Cell3.ID = 2; this.Table1_Cell3.JoinCells = new int[0]; this.Table1_Cell3.Name = "Table1_Cell3"; this.Table1_Cell3.ParentJoin = 3; this.Table1_Cell3.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell3.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell3.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell3.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell3.Guid = null; this.Table1_Cell3.Indicator = null; this.Table1_Cell3.Interaction = null; this.Table1_Cell3.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell3.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell3.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell4 // this.Table1_Cell4 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell4.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(0, 0, 19, 0.8); this.Table1_Cell4.ID = 3; this.Table1_Cell4.Join = true; this.Table1_Cell4.JoinCells = new int[] { 0, 1, 2, 3}; this.Table1_Cell4.JoinHeight = 1; this.Table1_Cell4.JoinWidth = 4; this.Table1_Cell4.Name = "Table1_Cell4"; this.Table1_Cell4.ParentJoin = 3; this.Table1_Cell4.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell4.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell4.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell4.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell4.Guid = null; this.Table1_Cell4.Indicator = null; this.Table1_Cell4.Interaction = null; this.Table1_Cell4.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell4.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell4.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell5 // this.Table1_Cell5 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell5.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(0, 0.8, 4.8, 0.8); this.Table1_Cell5.ID = 5; this.Table1_Cell5.JoinCells = new int[0]; this.Table1_Cell5.Name = "Table1_Cell5"; this.Table1_Cell5.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell5.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell5.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell5.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell5.Guid = null; this.Table1_Cell5.Indicator = null; this.Table1_Cell5.Interaction = null; this.Table1_Cell5.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell5.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell5.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell6 // this.Table1_Cell6 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell6.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(4.8, 0.8, 4.8, 0.8); this.Table1_Cell6.Enabled = false; this.Table1_Cell6.ID = 6; this.Table1_Cell6.JoinCells = new int[0]; this.Table1_Cell6.Name = "Table1_Cell6"; this.Table1_Cell6.ParentJoin = 8; this.Table1_Cell6.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell6.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell6.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell6.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell6.Guid = null; this.Table1_Cell6.Indicator = null; this.Table1_Cell6.Interaction = null; this.Table1_Cell6.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell6.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell6.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell7 // this.Table1_Cell7 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell7.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(9.6, 0.8, 4.8, 0.8); this.Table1_Cell7.Enabled = false; this.Table1_Cell7.ID = 7; this.Table1_Cell7.JoinCells = new int[0]; this.Table1_Cell7.Name = "Table1_Cell7"; this.Table1_Cell7.ParentJoin = 8; this.Table1_Cell7.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell7.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell7.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell7.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell7.Guid = null; this.Table1_Cell7.Indicator = null; this.Table1_Cell7.Interaction = null; this.Table1_Cell7.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell7.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell7.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell8 // this.Table1_Cell8 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell8.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(4.8, 0.8, 14.2, 0.8); this.Table1_Cell8.ID = 8; this.Table1_Cell8.Join = true; this.Table1_Cell8.JoinCells = new int[] { 6, 7, 8}; this.Table1_Cell8.JoinHeight = 1; this.Table1_Cell8.JoinWidth = 3; this.Table1_Cell8.Name = "Table1_Cell8"; this.Table1_Cell8.ParentJoin = 8; this.Table1_Cell8.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell8.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell8.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell8.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell8.Guid = null; this.Table1_Cell8.Indicator = null; this.Table1_Cell8.Interaction = null; this.Table1_Cell8.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell8.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell8.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell9 // this.Table1_Cell9 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell9.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(0, 1.6, 4.8, 0.8); this.Table1_Cell9.ID = 10; this.Table1_Cell9.JoinCells = new int[0]; this.Table1_Cell9.Name = "Table1_Cell9"; this.Table1_Cell9.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell9.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell9.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell9.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell9.Guid = null; this.Table1_Cell9.Indicator = null; this.Table1_Cell9.Interaction = null; this.Table1_Cell9.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell9.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell9.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell10 // this.Table1_Cell10 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell10.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(4.8, 1.6, 4.8, 0.8); this.Table1_Cell10.ID = 11; this.Table1_Cell10.JoinCells = new int[0]; this.Table1_Cell10.Name = "Table1_Cell10"; this.Table1_Cell10.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell10.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell10.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell10.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell10.Guid = null; this.Table1_Cell10.Indicator = null; this.Table1_Cell10.Interaction = null; this.Table1_Cell10.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell10.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell10.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell11 // this.Table1_Cell11 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell11.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(9.6, 1.6, 4.8, 0.8); this.Table1_Cell11.Enabled = false; this.Table1_Cell11.ID = 12; this.Table1_Cell11.JoinCells = new int[0]; this.Table1_Cell11.Name = "Table1_Cell11"; this.Table1_Cell11.ParentJoin = 13; this.Table1_Cell11.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell11.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell11.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell11.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell11.Guid = null; this.Table1_Cell11.Indicator = null; this.Table1_Cell11.Interaction = null; this.Table1_Cell11.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell11.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell11.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell12 // this.Table1_Cell12 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell12.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(9.6, 1.6, 9.4, 0.8); this.Table1_Cell12.ID = 13; this.Table1_Cell12.Join = true; this.Table1_Cell12.JoinCells = new int[] { 12, 13}; this.Table1_Cell12.JoinHeight = 1; this.Table1_Cell12.JoinWidth = 2; this.Table1_Cell12.Name = "Table1_Cell12"; this.Table1_Cell12.ParentJoin = 13; this.Table1_Cell12.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell12.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell12.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell12.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell12.Guid = null; this.Table1_Cell12.Indicator = null; this.Table1_Cell12.Interaction = null; this.Table1_Cell12.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell12.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell12.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell13 // this.Table1_Cell13 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell13.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(0, 2.4, 4.8, 0.8); this.Table1_Cell13.ID = 15; this.Table1_Cell13.JoinCells = new int[0]; this.Table1_Cell13.Name = "Table1_Cell13"; this.Table1_Cell13.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell13.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell13.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell13.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell13.Guid = null; this.Table1_Cell13.Indicator = null; this.Table1_Cell13.Interaction = null; this.Table1_Cell13.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell13.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell13.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell14 // this.Table1_Cell14 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell14.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(4.8, 2.4, 4.8, 0.8); this.Table1_Cell14.ID = 16; this.Table1_Cell14.JoinCells = new int[0]; this.Table1_Cell14.Name = "Table1_Cell14"; this.Table1_Cell14.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell14.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell14.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell14.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell14.Guid = null; this.Table1_Cell14.Indicator = null; this.Table1_Cell14.Interaction = null; this.Table1_Cell14.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell14.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell14.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell15 // this.Table1_Cell15 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell15.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(9.6, 2.4, 4.8, 0.8); this.Table1_Cell15.ID = 17; this.Table1_Cell15.JoinCells = new int[0]; this.Table1_Cell15.Name = "Table1_Cell15"; this.Table1_Cell15.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell15.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell15.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell15.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell15.Guid = null; this.Table1_Cell15.Indicator = null; this.Table1_Cell15.Interaction = null; this.Table1_Cell15.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell15.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell15.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); // // Table1_Cell16 // this.Table1_Cell16 = new Stimulsoft.Report.Components.Table.StiTableCell(); this.Table1_Cell16.ClientRectangle = new Stimulsoft.Base.Drawing.RectangleD(14.4, 2.4, 4.6, 0.8); this.Table1_Cell16.ID = 18; this.Table1_Cell16.JoinCells = new int[0]; this.Table1_Cell16.Name = "Table1_Cell16"; this.Table1_Cell16.Restrictions = (((Stimulsoft.Report.Components.StiRestrictions.None | Stimulsoft.Report.Components.StiRestrictions.AllowMove) | Stimulsoft.Report.Components.StiRestrictions.AllowSelect) | Stimulsoft.Report.Components.StiRestrictions.AllowChange); this.Table1_Cell16.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.All, System.Drawing.Color.FromArgb(255, 105, 105, 105), 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(255, 105, 105, 105)), false); this.Table1_Cell16.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent); this.Table1_Cell16.Font = new System.Drawing.Font("Arial", 9F); this.Table1_Cell16.Guid = null; this.Table1_Cell16.Indicator = null; this.Table1_Cell16.Interaction = null; this.Table1_Cell16.Margins = new Stimulsoft.Report.Components.StiMargins(0, 0, 0, 0); this.Table1_Cell16.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black); this.Table1_Cell16.TextOptions = new Stimulsoft.Base.Drawing.StiTextOptions(false, false, false, 0F, System.Drawing.Text.HotkeyPrefix.None, System.Drawing.StringTrimming.None); this.Table1.Guid = null; this.Table1.Interaction = null; this.Table1.MasterComponent = null; this.Page1.ExcelSheetValue = null; this.Page1.Interaction = null; this.Page1.Margins = new Stimulsoft.Report.Components.StiMargins(1, 1, 1, 1); this.Page1_Watermark = new Stimulsoft.Report.Components.StiWatermark(); this.Page1_Watermark.Font = new System.Drawing.Font("Arial", 100F); this.Page1_Watermark.Image = null; this.Page1_Watermark.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(50, 0, 0, 0)); this.Report_PrinterSettings = new Stimulsoft.Report.Print.StiPrinterSettings(); this.PrinterSettings = this.Report_PrinterSettings; this.Page1.Report = this; this.Page1.Watermark = this.Page1_Watermark; this.Table1.Page = this.Page1; this.Table1.Parent = this.Page1; this.Table1_Cell1.Page = this.Page1; this.Table1_Cell1.Parent = this.Table1; this.Table1_Cell2.Page = this.Page1; this.Table1_Cell2.Parent = this.Table1; this.Table1_Cell3.Page = this.Page1; this.Table1_Cell3.Parent = this.Table1; this.Table1_Cell4.Page = this.Page1; this.Table1_Cell4.Parent = this.Table1; this.Table1_Cell5.Page = this.Page1; this.Table1_Cell5.Parent = this.Table1; this.Table1_Cell6.Page = this.Page1; this.Table1_Cell6.Parent = this.Table1; this.Table1_Cell7.Page = this.Page1; this.Table1_Cell7.Parent = this.Table1; this.Table1_Cell8.Page = this.Page1; this.Table1_Cell8.Parent = this.Table1; this.Table1_Cell9.Page = this.Page1; this.Table1_Cell9.Parent = this.Table1; this.Table1_Cell10.Page = this.Page1; this.Table1_Cell10.Parent = this.Table1; this.Table1_Cell11.Page = this.Page1; this.Table1_Cell11.Parent = this.Table1; this.Table1_Cell12.Page = this.Page1; this.Table1_Cell12.Parent = this.Table1; this.Table1_Cell13.Page = this.Page1; this.Table1_Cell13.Parent = this.Table1; this.Table1_Cell14.Page = this.Page1; this.Table1_Cell14.Parent = this.Table1; this.Table1_Cell15.Page = this.Page1; this.Table1_Cell15.Parent = this.Table1; this.Table1_Cell16.Page = this.Page1; this.Table1_Cell16.Parent = this.Table1; // // Add to Table1.Components // this.Table1.Components.Clear(); this.Table1.Components.AddRange(new Stimulsoft.Report.Components.StiComponent[] { this.Table1_Cell1, this.Table1_Cell2, this.Table1_Cell3, this.Table1_Cell4, this.Table1_Cell5, this.Table1_Cell6, this.Table1_Cell7, this.Table1_Cell8, this.Table1_Cell9, this.Table1_Cell10, this.Table1_Cell11, this.Table1_Cell12, this.Table1_Cell13, this.Table1_Cell14, this.Table1_Cell15, this.Table1_Cell16}); // // Add to Page1.Components // this.Page1.Components.Clear(); this.Page1.Components.AddRange(new Stimulsoft.Report.Components.StiComponent[] { this.Table1}); // // Add to Pages // this.Pages.Clear(); this.Pages.AddRange(new Stimulsoft.Report.Components.StiPage[] { this.Page1}); this.Dictionary.Relations.Add(this.ParentOrders); this.Dictionary.Relations.Add(this.ParentProducts); this.Dictionary.Relations.Add(this.ParentCustomers); this.Dictionary.Relations.Add(this.ParentEmployees); this.Dictionary.Relations.Add(this.ParentShippers); this.Dictionary.Relations.Add(this.ParentCategories); this.Dictionary.Relations.Add(this.ParentSuppliers); this.Categories.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("CategoryID", "CategoryID", "CategoryID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("CategoryName", "CategoryName", "CategoryName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Description", "Description", "Description", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Picture", "Picture", "Picture", typeof(byte[]))}); this.DataSources.Add(this.Categories); this.Customers.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("CustomerID", "CustomerID", "CustomerID", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("CompanyName", "CompanyName", "CompanyName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ContactName", "ContactName", "ContactName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ContactTitle", "ContactTitle", "ContactTitle", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Address", "Address", "Address", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("City", "City", "City", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Region", "Region", "Region", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("PostalCode", "PostalCode", "PostalCode", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Country", "Country", "Country", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Phone", "Phone", "Phone", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Fax", "Fax", "Fax", typeof(string))}); this.DataSources.Add(this.Customers); this.Employees.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("EmployeeID", "EmployeeID", "EmployeeID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("LastName", "LastName", "LastName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("FirstName", "FirstName", "FirstName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Title", "Title", "Title", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("TitleOfCourtesy", "TitleOfCourtesy", "TitleOfCourtesy", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("BirthDate", "BirthDate", "BirthDate", typeof(DateTime)), new Stimulsoft.Report.Dictionary.StiDataColumn("HireDate", "HireDate", "HireDate", typeof(DateTime)), new Stimulsoft.Report.Dictionary.StiDataColumn("Address", "Address", "Address", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("City", "City", "City", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Region", "Region", "Region", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("PostalCode", "PostalCode", "PostalCode", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Country", "Country", "Country", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("HomePhone", "HomePhone", "HomePhone", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Extension", "Extension", "Extension", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Photo", "Photo", "Photo", typeof(byte[])), new Stimulsoft.Report.Dictionary.StiDataColumn("Notes", "Notes", "Notes", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ReportsTo", "ReportsTo", "ReportsTo", typeof(int))}); this.DataSources.Add(this.Employees); this.Order_Details.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("OrderID", "OrderID", "OrderID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("UnitPrice", "UnitPrice", "UnitPrice", typeof(decimal)), new Stimulsoft.Report.Dictionary.StiDataColumn("Quantity", "Quantity", "Quantity", typeof(short)), new Stimulsoft.Report.Dictionary.StiDataColumn("Discount", "Discount", "Discount", typeof(float))}); this.DataSources.Add(this.Order_Details); this.Orders.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("OrderID", "OrderID", "OrderID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("CustomerID", "CustomerID", "CustomerID", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("EmployeeID", "EmployeeID", "EmployeeID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("OrderDate", "OrderDate", "OrderDate", typeof(DateTime)), new Stimulsoft.Report.Dictionary.StiDataColumn("RequiredDate", "RequiredDate", "RequiredDate", typeof(DateTime)), new Stimulsoft.Report.Dictionary.StiDataColumn("ShippedDate", "ShippedDate", "ShippedDate", typeof(DateTime)), new Stimulsoft.Report.Dictionary.StiDataColumn("ShipVia", "ShipVia", "ShipVia", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("Freight", "Freight", "Freight", typeof(decimal)), new Stimulsoft.Report.Dictionary.StiDataColumn("ShipName", "ShipName", "ShipName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ShipAddress", "ShipAddress", "ShipAddress", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ShipCity", "ShipCity", "ShipCity", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ShipRegion", "ShipRegion", "ShipRegion", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ShipPostalCode", "ShipPostalCode", "ShipPostalCode", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ShipCountry", "ShipCountry", "ShipCountry", typeof(string))}); this.DataSources.Add(this.Orders); this.Products.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("ProductName", "ProductName", "ProductName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("SupplierID", "SupplierID", "SupplierID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("CategoryID", "CategoryID", "CategoryID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("QuantityPerUnit", "QuantityPerUnit", "QuantityPerUnit", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("UnitPrice", "UnitPrice", "UnitPrice", typeof(decimal)), new Stimulsoft.Report.Dictionary.StiDataColumn("UnitsInStock", "UnitsInStock", "UnitsInStock", typeof(short)), new Stimulsoft.Report.Dictionary.StiDataColumn("UnitsOnOrder", "UnitsOnOrder", "UnitsOnOrder", typeof(short)), new Stimulsoft.Report.Dictionary.StiDataColumn("ReorderLevel", "ReorderLevel", "ReorderLevel", typeof(short)), new Stimulsoft.Report.Dictionary.StiDataColumn("Discontinued", "Discontinued", "Discontinued", typeof(bool))}); this.DataSources.Add(this.Products); this.Shippers.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("ShipperID", "ShipperID", "ShipperID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("CompanyName", "CompanyName", "CompanyName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Phone", "Phone", "Phone", typeof(string))}); this.DataSources.Add(this.Shippers); this.Suppliers.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("SupplierID", "SupplierID", "SupplierID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("CompanyName", "CompanyName", "CompanyName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ContactName", "ContactName", "ContactName", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("ContactTitle", "ContactTitle", "ContactTitle", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Address", "Address", "Address", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("City", "City", "City", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Region", "Region", "Region", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("PostalCode", "PostalCode", "PostalCode", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Country", "Country", "Country", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Phone", "Phone", "Phone", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Fax", "Fax", "Fax", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("HomePage", "HomePage", "HomePage", typeof(string))}); this.DataSources.Add(this.Suppliers); this.Countries.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("CountriesID", "CountriesID", "CountriesID", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("Flag", "Flag", "Flag", typeof(byte[])), new Stimulsoft.Report.Dictionary.StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string))}); this.DataSources.Add(this.Countries); this.States.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("Name", "Name", "Name", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("USPS", "USPS", "USPS", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Population", "Population", "Population", typeof(int)), new Stimulsoft.Report.Dictionary.StiDataColumn("Capital", "Capital", "Capital", typeof(string))}); this.DataSources.Add(this.States); this.Auto.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("Rank", "Rank", "Rank", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Country", "Country", "Country", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Year2009", "Year2009", "Year2009", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Year2005", "Year2005", "Year2005", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Year2000", "Year2000", "Year2000", typeof(double))}); this.DataSources.Add(this.Auto); this.GlobalGrowth.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("Region", "Region", "Region", typeof(string)), new Stimulsoft.Report.Dictionary.StiDataColumn("Year2006", "Year2006", "Year2006", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Year2007", "Year2007", "Year2007", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Year2008", "Year2008", "Year2008", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Year2009", "Year2009", "Year2009", typeof(double))}); this.DataSources.Add(this.GlobalGrowth); this.Opec.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("Year", "Year", "Year", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Iran", "Iran", "Iran", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Iraq", "Iraq", "Iraq", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Kuwait", "Kuwait", "Kuwait", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Saudi Arabia", "Saudi Arabia", "Saudi Arabia", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("UAE", "UAE", "UAE", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Venezuela", "Venezuela", "Venezuela", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Libya", "Libya", "Libya", typeof(double)), new Stimulsoft.Report.Dictionary.StiDataColumn("Nigeria", "Nigeria", "Nigeria", typeof(double))}); this.DataSources.Add(this.Opec); this.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiXmlDatabase("Connection", "C:\\Program Files\\Stimulsoft Reports.Ultimate 2012.3 Trial\\Bin\\Data\\Demo.xsd", "C:\\Program Files\\Stimulsoft Reports.Ultimate 2012.3 Trial\\Bin\\Data\\Demo.xml")); } #region Relation ParentOrders public class ParentOrdersRelation : Stimulsoft.Report.Dictionary.StiDataRow { public ParentOrdersRelation(Stimulsoft.Report.Dictionary.StiDataRow dataRow) : base(dataRow) { } public virtual int OrderID { get { return ((int)(StiReport.ChangeType(this["OrderID"], typeof(int), true))); } } public virtual string CustomerID { get { return ((string)(StiReport.ChangeType(this["CustomerID"], typeof(string), true))); } } public virtual int EmployeeID { get { return ((int)(StiReport.ChangeType(this["EmployeeID"], typeof(int), true))); } } public virtual DateTime OrderDate { get { return ((DateTime)(StiReport.ChangeType(this["OrderDate"], typeof(DateTime), true))); } } public virtual DateTime RequiredDate { get { return ((DateTime)(StiReport.ChangeType(this["RequiredDate"], typeof(DateTime), true))); } } public virtual DateTime ShippedDate { get { return ((DateTime)(StiReport.ChangeType(this["ShippedDate"], typeof(DateTime), true))); } } public virtual int ShipVia { get { return ((int)(StiReport.ChangeType(this["ShipVia"], typeof(int), true))); } } public virtual decimal Freight { get { return ((decimal)(StiReport.ChangeType(this["Freight"], typeof(decimal), true))); } } public virtual string ShipName { get { return ((string)(StiReport.ChangeType(this["ShipName"], typeof(string), true))); } } public virtual string ShipAddress { get { return ((string)(StiReport.ChangeType(this["ShipAddress"], typeof(string), true))); } } public virtual string ShipCity { get { return ((string)(StiReport.ChangeType(this["ShipCity"], typeof(string), true))); } } public virtual string ShipRegion { get { return ((string)(StiReport.ChangeType(this["ShipRegion"], typeof(string), true))); } } public virtual string ShipPostalCode { get { return ((string)(StiReport.ChangeType(this["ShipPostalCode"], typeof(string), true))); } } public virtual string ShipCountry { get { return ((string)(StiReport.ChangeType(this["ShipCountry"], typeof(string), true))); } } public virtual ParentCustomersRelation Customers { get { return new ParentCustomersRelation(this.GetParentData("CustomersOrders")); } } public virtual ParentEmployeesRelation Employees { get { return new ParentEmployeesRelation(this.GetParentData("EmployeesOrders")); } } public virtual ParentShippersRelation Shippers { get { return new ParentShippersRelation(this.GetParentData("ShippersOrders")); } } } #endregion Relation ParentOrders #region Relation ParentProducts public class ParentProductsRelation : Stimulsoft.Report.Dictionary.StiDataRow { public ParentProductsRelation(Stimulsoft.Report.Dictionary.StiDataRow dataRow) : base(dataRow) { } public virtual int ProductID { get { return ((int)(StiReport.ChangeType(this["ProductID"], typeof(int), true))); } } public virtual string ProductName { get { return ((string)(StiReport.ChangeType(this["ProductName"], typeof(string), true))); } } public virtual int SupplierID { get { return ((int)(StiReport.ChangeType(this["SupplierID"], typeof(int), true))); } } public virtual int CategoryID { get { return ((int)(StiReport.ChangeType(this["CategoryID"], typeof(int), true))); } } public virtual string QuantityPerUnit { get { return ((string)(StiReport.ChangeType(this["QuantityPerUnit"], typeof(string), true))); } } public virtual decimal UnitPrice { get { return ((decimal)(StiReport.ChangeType(this["UnitPrice"], typeof(decimal), true))); } } public virtual short UnitsInStock { get { return ((short)(StiReport.ChangeType(this["UnitsInStock"], typeof(short), true))); } } public virtual short UnitsOnOrder { get { return ((short)(StiReport.ChangeType(this["UnitsOnOrder"], typeof(short), true))); } } public virtual short ReorderLevel { get { return ((short)(StiReport.ChangeType(this["ReorderLevel"], typeof(short), true))); } } public virtual bool Discontinued { get { return ((bool)(StiReport.ChangeType(this["Discontinued"], typeof(bool), true))); } } public virtual ParentCategoriesRelation Categories { get { return new ParentCategoriesRelation(this.GetParentData("CategoriesProducts")); } } public virtual ParentSuppliersRelation Suppliers { get { return new ParentSuppliersRelation(this.GetParentData("SuppliersProducts")); } } } #endregion Relation ParentProducts #region Relation ParentCustomers public class ParentCustomersRelation : Stimulsoft.Report.Dictionary.StiDataRow { public ParentCustomersRelation(Stimulsoft.Report.Dictionary.StiDataRow dataRow) : base(dataRow) { } public virtual string CustomerID { get { return ((string)(StiReport.ChangeType(this["CustomerID"], typeof(string), true))); } } public virtual string CompanyName { get { return ((string)(StiReport.ChangeType(this["CompanyName"], typeof(string), true))); } } public virtual string ContactName { get { return ((string)(StiReport.ChangeType(this["ContactName"], typeof(string), true))); } } public virtual string ContactTitle { get { return ((string)(StiReport.ChangeType(this["ContactTitle"], typeof(string), true))); } } public virtual string Address { get { return ((string)(StiReport.ChangeType(this["Address"], typeof(string), true))); } } public virtual string City { get { return ((string)(StiReport.ChangeType(this["City"], typeof(string), true))); } } public virtual string Region { get { return ((string)(StiReport.ChangeType(this["Region"], typeof(string), true))); } } public virtual string PostalCode { get { return ((string)(StiReport.ChangeType(this["PostalCode"], typeof(string), true))); } } public virtual string Country { get { return ((string)(StiReport.ChangeType(this["Country"], typeof(string), true))); } } public virtual string Phone { get { return ((string)(StiReport.ChangeType(this["Phone"], typeof(string), true))); } } public virtual string Fax { get { return ((string)(StiReport.ChangeType(this["Fax"], typeof(string), true))); } } } #endregion Relation ParentCustomers #region Relation ParentEmployees public class ParentEmployeesRelation : Stimulsoft.Report.Dictionary.StiDataRow { public ParentEmployeesRelation(Stimulsoft.Report.Dictionary.StiDataRow dataRow) : base(dataRow) { } public virtual int EmployeeID { get { return ((int)(StiReport.ChangeType(this["EmployeeID"], typeof(int), true))); } } public virtual string LastName { get { return ((string)(StiReport.ChangeType(this["LastName"], typeof(string), true))); } } public virtual string FirstName { get { return ((string)(StiReport.ChangeType(this["FirstName"], typeof(string), true))); } } public virtual string Title { get { return ((string)(StiReport.ChangeType(this["Title"], typeof(string), true))); } } public virtual string TitleOfCourtesy { get { return ((string)(StiReport.ChangeType(this["TitleOfCourtesy"], typeof(string), true))); } } public virtual DateTime BirthDate { get { return ((DateTime)(StiReport.ChangeType(this["BirthDate"], typeof(DateTime), true))); } } public virtual DateTime HireDate { get { return ((DateTime)(StiReport.ChangeType(this["HireDate"], typeof(DateTime), true))); } } public virtual string Address { get { return ((string)(StiReport.ChangeType(this["Address"], typeof(string), true))); } } public virtual string City { get { return ((string)(StiReport.ChangeType(this["City"], typeof(string), true))); } } public virtual string Region { get { return ((string)(StiReport.ChangeType(this["Region"], typeof(string), true))); } } public virtual string PostalCode { get { return ((string)(StiReport.ChangeType(this["PostalCode"], typeof(string), true))); } } public virtual string Country { get { return ((string)(StiReport.ChangeType(this["Country"], typeof(string), true))); } } public virtual string HomePhone { get { return ((string)(StiReport.ChangeType(this["HomePhone"], typeof(string), true))); } } public virtual string Extension { get { return ((string)(StiReport.ChangeType(this["Extension"], typeof(string), true))); } } public virtual byte[] Photo { get { return ((byte[])(StiReport.ChangeType(this["Photo"], typeof(byte[]), true))); } } public virtual string Notes { get { return ((string)(StiReport.ChangeType(this["Notes"], typeof(string), true))); } } public virtual int ReportsTo { get { return ((int)(StiReport.ChangeType(this["ReportsTo"], typeof(int), true))); } } } #endregion Relation ParentEmployees #region Relation ParentShippers public class ParentShippersRelation : Stimulsoft.Report.Dictionary.StiDataRow { public ParentShippersRelation(Stimulsoft.Report.Dictionary.StiDataRow dataRow) : base(dataRow) { } public virtual int ShipperID { get { return ((int)(StiReport.ChangeType(this["ShipperID"], typeof(int), true))); } } public virtual string CompanyName { get { return ((string)(StiReport.ChangeType(this["CompanyName"], typeof(string), true))); } } public virtual string Phone { get { return ((string)(StiReport.ChangeType(this["Phone"], typeof(string), true))); } } } #endregion Relation ParentShippers #region Relation ParentCategories public class ParentCategoriesRelation : Stimulsoft.Report.Dictionary.StiDataRow { public ParentCategoriesRelation(Stimulsoft.Report.Dictionary.StiDataRow dataRow) : base(dataRow) { } public virtual int CategoryID { get { return ((int)(StiReport.ChangeType(this["CategoryID"], typeof(int), true))); } } public virtual string CategoryName { get { return ((string)(StiReport.ChangeType(this["CategoryName"], typeof(string), true))); } } public virtual string Description { get { return ((string)(StiReport.ChangeType(this["Description"], typeof(string), true))); } } public virtual byte[] Picture { get { return ((byte[])(StiReport.ChangeType(this["Picture"], typeof(byte[]), true))); } } } #endregion Relation ParentCategories #region Relation ParentSuppliers public class ParentSuppliersRelation : Stimulsoft.Report.Dictionary.StiDataRow { public ParentSuppliersRelation(Stimulsoft.Report.Dictionary.StiDataRow dataRow) : base(dataRow) { } public virtual int SupplierID { get { return ((int)(StiReport.ChangeType(this["SupplierID"], typeof(int), true))); } } public virtual string CompanyName { get { return ((string)(StiReport.ChangeType(this["CompanyName"], typeof(string), true))); } } public virtual string ContactName { get { return ((string)(StiReport.ChangeType(this["ContactName"], typeof(string), true))); } } public virtual string ContactTitle { get { return ((string)(StiReport.ChangeType(this["ContactTitle"], typeof(string), true))); } } public virtual string Address { get { return ((string)(StiReport.ChangeType(this["Address"], typeof(string), true))); } } public virtual string City { get { return ((string)(StiReport.ChangeType(this["City"], typeof(string), true))); } } public virtual string Region { get { return ((string)(StiReport.ChangeType(this["Region"], typeof(string), true))); } } public virtual string PostalCode { get { return ((string)(StiReport.ChangeType(this["PostalCode"], typeof(string), true))); } } public virtual string Country { get { return ((string)(StiReport.ChangeType(this["Country"], typeof(string), true))); } } public virtual string Phone { get { return ((string)(StiReport.ChangeType(this["Phone"], typeof(string), true))); } } public virtual string Fax { get { return ((string)(StiReport.ChangeType(this["Fax"], typeof(string), true))); } } public virtual string HomePage { get { return ((string)(StiReport.ChangeType(this["HomePage"], typeof(string), true))); } } } #endregion Relation ParentSuppliers #region DataSource Categories public class CategoriesDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public CategoriesDataSource() : base("Connection.Categories", "Categories") { } public virtual int CategoryID { get { return ((int)(StiReport.ChangeType(this["CategoryID"], typeof(int), true))); } } public virtual string CategoryName { get { return ((string)(StiReport.ChangeType(this["CategoryName"], typeof(string), true))); } } public virtual string Description { get { return ((string)(StiReport.ChangeType(this["Description"], typeof(string), true))); } } public virtual byte[] Picture { get { return ((byte[])(StiReport.ChangeType(this["Picture"], typeof(byte[]), true))); } } } #endregion DataSource Categories #region DataSource Customers public class CustomersDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public CustomersDataSource() : base("Connection.Customers", "Customers") { } public virtual string CustomerID { get { return ((string)(StiReport.ChangeType(this["CustomerID"], typeof(string), true))); } } public virtual string CompanyName { get { return ((string)(StiReport.ChangeType(this["CompanyName"], typeof(string), true))); } } public virtual string ContactName { get { return ((string)(StiReport.ChangeType(this["ContactName"], typeof(string), true))); } } public virtual string ContactTitle { get { return ((string)(StiReport.ChangeType(this["ContactTitle"], typeof(string), true))); } } public virtual string Address { get { return ((string)(StiReport.ChangeType(this["Address"], typeof(string), true))); } } public virtual string City { get { return ((string)(StiReport.ChangeType(this["City"], typeof(string), true))); } } public virtual string Region { get { return ((string)(StiReport.ChangeType(this["Region"], typeof(string), true))); } } public virtual string PostalCode { get { return ((string)(StiReport.ChangeType(this["PostalCode"], typeof(string), true))); } } public virtual string Country { get { return ((string)(StiReport.ChangeType(this["Country"], typeof(string), true))); } } public virtual string Phone { get { return ((string)(StiReport.ChangeType(this["Phone"], typeof(string), true))); } } public virtual string Fax { get { return ((string)(StiReport.ChangeType(this["Fax"], typeof(string), true))); } } } #endregion DataSource Customers #region DataSource Employees public class EmployeesDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public EmployeesDataSource() : base("Connection.Employees", "Employees") { } public virtual int EmployeeID { get { return ((int)(StiReport.ChangeType(this["EmployeeID"], typeof(int), true))); } } public virtual string LastName { get { return ((string)(StiReport.ChangeType(this["LastName"], typeof(string), true))); } } public virtual string FirstName { get { return ((string)(StiReport.ChangeType(this["FirstName"], typeof(string), true))); } } public virtual string Title { get { return ((string)(StiReport.ChangeType(this["Title"], typeof(string), true))); } } public virtual string TitleOfCourtesy { get { return ((string)(StiReport.ChangeType(this["TitleOfCourtesy"], typeof(string), true))); } } public virtual DateTime BirthDate { get { return ((DateTime)(StiReport.ChangeType(this["BirthDate"], typeof(DateTime), true))); } } public virtual DateTime HireDate { get { return ((DateTime)(StiReport.ChangeType(this["HireDate"], typeof(DateTime), true))); } } public virtual string Address { get { return ((string)(StiReport.ChangeType(this["Address"], typeof(string), true))); } } public virtual string City { get { return ((string)(StiReport.ChangeType(this["City"], typeof(string), true))); } } public virtual string Region { get { return ((string)(StiReport.ChangeType(this["Region"], typeof(string), true))); } } public virtual string PostalCode { get { return ((string)(StiReport.ChangeType(this["PostalCode"], typeof(string), true))); } } public virtual string Country { get { return ((string)(StiReport.ChangeType(this["Country"], typeof(string), true))); } } public virtual string HomePhone { get { return ((string)(StiReport.ChangeType(this["HomePhone"], typeof(string), true))); } } public virtual string Extension { get { return ((string)(StiReport.ChangeType(this["Extension"], typeof(string), true))); } } public virtual byte[] Photo { get { return ((byte[])(StiReport.ChangeType(this["Photo"], typeof(byte[]), true))); } } public virtual string Notes { get { return ((string)(StiReport.ChangeType(this["Notes"], typeof(string), true))); } } public virtual int ReportsTo { get { return ((int)(StiReport.ChangeType(this["ReportsTo"], typeof(int), true))); } } } #endregion DataSource Employees #region DataSource Order_Details public class Order_DetailsDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public Order_DetailsDataSource() : base("Connection.Order Details", "Order Details") { } public virtual int OrderID { get { return ((int)(StiReport.ChangeType(this["OrderID"], typeof(int), true))); } } public virtual int ProductID { get { return ((int)(StiReport.ChangeType(this["ProductID"], typeof(int), true))); } } public virtual decimal UnitPrice { get { return ((decimal)(StiReport.ChangeType(this["UnitPrice"], typeof(decimal), true))); } } public virtual short Quantity { get { return ((short)(StiReport.ChangeType(this["Quantity"], typeof(short), true))); } } public virtual float Discount { get { return ((float)(StiReport.ChangeType(this["Discount"], typeof(float), true))); } } public virtual ParentOrdersRelation Orders { get { return new ParentOrdersRelation(this.GetParentData("OrdersOrderDetails")); } } public virtual ParentProductsRelation Products { get { return new ParentProductsRelation(this.GetParentData("ProductsOrderDetails")); } } } #endregion DataSource Order_Details #region DataSource Orders public class OrdersDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public OrdersDataSource() : base("Connection.Orders", "Orders") { } public virtual int OrderID { get { return ((int)(StiReport.ChangeType(this["OrderID"], typeof(int), true))); } } public virtual string CustomerID { get { return ((string)(StiReport.ChangeType(this["CustomerID"], typeof(string), true))); } } public virtual int EmployeeID { get { return ((int)(StiReport.ChangeType(this["EmployeeID"], typeof(int), true))); } } public virtual DateTime OrderDate { get { return ((DateTime)(StiReport.ChangeType(this["OrderDate"], typeof(DateTime), true))); } } public virtual DateTime RequiredDate { get { return ((DateTime)(StiReport.ChangeType(this["RequiredDate"], typeof(DateTime), true))); } } public virtual DateTime ShippedDate { get { return ((DateTime)(StiReport.ChangeType(this["ShippedDate"], typeof(DateTime), true))); } } public virtual int ShipVia { get { return ((int)(StiReport.ChangeType(this["ShipVia"], typeof(int), true))); } } public virtual decimal Freight { get { return ((decimal)(StiReport.ChangeType(this["Freight"], typeof(decimal), true))); } } public virtual string ShipName { get { return ((string)(StiReport.ChangeType(this["ShipName"], typeof(string), true))); } } public virtual string ShipAddress { get { return ((string)(StiReport.ChangeType(this["ShipAddress"], typeof(string), true))); } } public virtual string ShipCity { get { return ((string)(StiReport.ChangeType(this["ShipCity"], typeof(string), true))); } } public virtual string ShipRegion { get { return ((string)(StiReport.ChangeType(this["ShipRegion"], typeof(string), true))); } } public virtual string ShipPostalCode { get { return ((string)(StiReport.ChangeType(this["ShipPostalCode"], typeof(string), true))); } } public virtual string ShipCountry { get { return ((string)(StiReport.ChangeType(this["ShipCountry"], typeof(string), true))); } } public virtual ParentCustomersRelation Customers { get { return new ParentCustomersRelation(this.GetParentData("CustomersOrders")); } } public virtual ParentEmployeesRelation Employees { get { return new ParentEmployeesRelation(this.GetParentData("EmployeesOrders")); } } public virtual ParentShippersRelation Shippers { get { return new ParentShippersRelation(this.GetParentData("ShippersOrders")); } } } #endregion DataSource Orders #region DataSource Products public class ProductsDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public ProductsDataSource() : base("Connection.Products", "Products") { } public virtual int ProductID { get { return ((int)(StiReport.ChangeType(this["ProductID"], typeof(int), true))); } } public virtual string ProductName { get { return ((string)(StiReport.ChangeType(this["ProductName"], typeof(string), true))); } } public virtual int SupplierID { get { return ((int)(StiReport.ChangeType(this["SupplierID"], typeof(int), true))); } } public virtual int CategoryID { get { return ((int)(StiReport.ChangeType(this["CategoryID"], typeof(int), true))); } } public virtual string QuantityPerUnit { get { return ((string)(StiReport.ChangeType(this["QuantityPerUnit"], typeof(string), true))); } } public virtual decimal UnitPrice { get { return ((decimal)(StiReport.ChangeType(this["UnitPrice"], typeof(decimal), true))); } } public virtual short UnitsInStock { get { return ((short)(StiReport.ChangeType(this["UnitsInStock"], typeof(short), true))); } } public virtual short UnitsOnOrder { get { return ((short)(StiReport.ChangeType(this["UnitsOnOrder"], typeof(short), true))); } } public virtual short ReorderLevel { get { return ((short)(StiReport.ChangeType(this["ReorderLevel"], typeof(short), true))); } } public virtual bool Discontinued { get { return ((bool)(StiReport.ChangeType(this["Discontinued"], typeof(bool), true))); } } public virtual ParentCategoriesRelation Categories { get { return new ParentCategoriesRelation(this.GetParentData("CategoriesProducts")); } } public virtual ParentSuppliersRelation Suppliers { get { return new ParentSuppliersRelation(this.GetParentData("SuppliersProducts")); } } } #endregion DataSource Products #region DataSource Shippers public class ShippersDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public ShippersDataSource() : base("Connection.Shippers", "Shippers") { } public virtual int ShipperID { get { return ((int)(StiReport.ChangeType(this["ShipperID"], typeof(int), true))); } } public virtual string CompanyName { get { return ((string)(StiReport.ChangeType(this["CompanyName"], typeof(string), true))); } } public virtual string Phone { get { return ((string)(StiReport.ChangeType(this["Phone"], typeof(string), true))); } } } #endregion DataSource Shippers #region DataSource Suppliers public class SuppliersDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public SuppliersDataSource() : base("Connection.Suppliers", "Suppliers") { } public virtual int SupplierID { get { return ((int)(StiReport.ChangeType(this["SupplierID"], typeof(int), true))); } } public virtual string CompanyName { get { return ((string)(StiReport.ChangeType(this["CompanyName"], typeof(string), true))); } } public virtual string ContactName { get { return ((string)(StiReport.ChangeType(this["ContactName"], typeof(string), true))); } } public virtual string ContactTitle { get { return ((string)(StiReport.ChangeType(this["ContactTitle"], typeof(string), true))); } } public virtual string Address { get { return ((string)(StiReport.ChangeType(this["Address"], typeof(string), true))); } } public virtual string City { get { return ((string)(StiReport.ChangeType(this["City"], typeof(string), true))); } } public virtual string Region { get { return ((string)(StiReport.ChangeType(this["Region"], typeof(string), true))); } } public virtual string PostalCode { get { return ((string)(StiReport.ChangeType(this["PostalCode"], typeof(string), true))); } } public virtual string Country { get { return ((string)(StiReport.ChangeType(this["Country"], typeof(string), true))); } } public virtual string Phone { get { return ((string)(StiReport.ChangeType(this["Phone"], typeof(string), true))); } } public virtual string Fax { get { return ((string)(StiReport.ChangeType(this["Fax"], typeof(string), true))); } } public virtual string HomePage { get { return ((string)(StiReport.ChangeType(this["HomePage"], typeof(string), true))); } } } #endregion DataSource Suppliers #region DataSource Countries public class CountriesDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public CountriesDataSource() : base("Connection.Countries", "Countries") { } public virtual int CountriesID { get { return ((int)(StiReport.ChangeType(this["CountriesID"], typeof(int), true))); } } public virtual byte[] Flag { get { return ((byte[])(StiReport.ChangeType(this["Flag"], typeof(byte[]), true))); } } public virtual string CountryName { get { return ((string)(StiReport.ChangeType(this["CountryName"], typeof(string), true))); } } } #endregion DataSource Countries #region DataSource States public class StatesDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public StatesDataSource() : base("Connection.States", "States") { } public new virtual string Name { get { return ((string)(StiReport.ChangeType(this["Name"], typeof(string), true))); } } public virtual string USPS { get { return ((string)(StiReport.ChangeType(this["USPS"], typeof(string), true))); } } public virtual int Population { get { return ((int)(StiReport.ChangeType(this["Population"], typeof(int), true))); } } public virtual string Capital { get { return ((string)(StiReport.ChangeType(this["Capital"], typeof(string), true))); } } } #endregion DataSource States #region DataSource Auto public class AutoDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public AutoDataSource() : base("Connection.Auto", "Auto") { } public virtual double Rank { get { return ((double)(StiReport.ChangeType(this["Rank"], typeof(double), true))); } } public virtual string Country { get { return ((string)(StiReport.ChangeType(this["Country"], typeof(string), true))); } } public virtual double Year2009 { get { return ((double)(StiReport.ChangeType(this["Year2009"], typeof(double), true))); } } public virtual double Year2005 { get { return ((double)(StiReport.ChangeType(this["Year2005"], typeof(double), true))); } } public virtual double Year2000 { get { return ((double)(StiReport.ChangeType(this["Year2000"], typeof(double), true))); } } } #endregion DataSource Auto #region DataSource GlobalGrowth public class GlobalGrowthDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public GlobalGrowthDataSource() : base("Connection.GlobalGrowth", "GlobalGrowth") { } public virtual string Region { get { return ((string)(StiReport.ChangeType(this["Region"], typeof(string), true))); } } public virtual double Year2006 { get { return ((double)(StiReport.ChangeType(this["Year2006"], typeof(double), true))); } } public virtual double Year2007 { get { return ((double)(StiReport.ChangeType(this["Year2007"], typeof(double), true))); } } public virtual double Year2008 { get { return ((double)(StiReport.ChangeType(this["Year2008"], typeof(double), true))); } } public virtual double Year2009 { get { return ((double)(StiReport.ChangeType(this["Year2009"], typeof(double), true))); } } } #endregion DataSource GlobalGrowth #region DataSource Opec public class OpecDataSource : Stimulsoft.Report.Dictionary.StiDataTableSource { public OpecDataSource() : base("Connection.Opec", "Opec") { } public virtual double Year { get { return ((double)(StiReport.ChangeType(this["Year"], typeof(double), true))); } } public virtual double Iran { get { return ((double)(StiReport.ChangeType(this["Iran"], typeof(double), true))); } } public virtual double Iraq { get { return ((double)(StiReport.ChangeType(this["Iraq"], typeof(double), true))); } } public virtual double Kuwait { get { return ((double)(StiReport.ChangeType(this["Kuwait"], typeof(double), true))); } } public virtual double Saudi_Arabia { get { return ((double)(StiReport.ChangeType(this["Saudi Arabia"], typeof(double), true))); } } public virtual double UAE { get { return ((double)(StiReport.ChangeType(this["UAE"], typeof(double), true))); } } public virtual double Venezuela { get { return ((double)(StiReport.ChangeType(this["Venezuela"], typeof(double), true))); } } public virtual double Libya { get { return ((double)(StiReport.ChangeType(this["Libya"], typeof(double), true))); } } public virtual double Nigeria { get { return ((double)(StiReport.ChangeType(this["Nigeria"], typeof(double), true))); } } } #endregion DataSource Opec #endregion StiReport Designer generated code - do not modify } }