public static XtraReportsDemos.MasterDetailReport.Report Fill(this XtraReportsDemos.MasterDetailReport.Report report) { var productsQuery = DataSources.Nwind.Products.AsEnumerable(); var categoriesQuery = DataSources.Nwind.Categories.AsEnumerable(); var products = from product in productsQuery join category in categoriesQuery on product.CategoryID equals category.CategoryID select new { CategoryName = category.CategoryName, CategoryID = product.CategoryID, Discontinued = product.Discontinued, ProductID = product.ProductID, ProductName = product.ProductName, QuantityPerUnit = product.QuantityPerUnit, SupplierID = product.SupplierID, UnitPrice = product.UnitPrice, }; products.CopyToDataTable(report.dsMasterDetail1.Products); DataSources.Nwind.Suppliers.CopyToDataTable(report.dsMasterDetail1.Suppliers); var orderDetailsQuery = DataSources.Nwind.Order_Details.AsEnumerable(); var orderDetails = from orderDetail in orderDetailsQuery select new { Discount = orderDetail.Discount, OrderID = orderDetail.OrderID, ProductID = orderDetail.ProductID, Quantity = orderDetail.Quantity, UnitPrice = orderDetail.UnitPrice, SubTotal = (decimal)(orderDetail.Quantity * orderDetail.UnitPrice) }; orderDetails.CopyToDataTable(report.dsMasterDetail1.Order_Details); return(report); }
internal override void ShowModule(bool firstShow) { base.ShowModule(firstShow); if (firstShow) { reportDesigner1.ContainerControl = this; XtraReport report = new XtraReportsDemos.MasterDetailReport.Report(); report.ReportPrintOptions.DetailCountAtDesignTime = 0; foreach (XtraReportBase item in report.AllControls <XtraReportBase>()) { item.ReportPrintOptions.DetailCountAtDesignTime = 0; } reportDesigner1.OpenReport(report); MainRibbon.AutoHideEmptyItems = true; MainRibbon.SelectedPage = MainRibbon.MergedPages.GetPageByText("VIEW"); MainRibbon.SelectedPage = MainRibbon.MergedPages.GetPageByName(ribbonPagePreview.Name); var reportControl = reportDesigner1.ActiveDesignPanel.GetService(typeof(DevExpress.XtraReports.Design.ReportTabControl)) as DevExpress.XtraReports.Design.ReportTabControl; if (reportControl == null || reportControl.PreviewControl == null) { return; } DevExpress.XtraBars.Docking.DockPanel navigationDockPanel = reportControl.PreviewControl.DockManager.Panels[new System.Guid("6b2e64eb-afd0-4676-bc3d-eca7e99946aa")]; if (navigationDockPanel != null) { navigationDockPanel.SavedDock = DevExpress.XtraBars.Docking.DockingStyle.Right; } return; } MainRibbon.SelectedPage = MainRibbon.MergedPages.GetPageByName(ribbonPagePreview.Name); }
internal override void ShowModule(bool firstShow) { base.ShowModule(firstShow); if(firstShow) { reportDesigner1.ContainerControl = this; XtraReport report = new XtraReportsDemos.MasterDetailReport.Report(); report.ReportPrintOptions.DetailCountAtDesignTime = 0; foreach(XtraReportBase item in report.AllControls<XtraReportBase>()) { item.ReportPrintOptions.DetailCountAtDesignTime = 0; } reportDesigner1.OpenReport(report); MainRibbon.AutoHideEmptyItems = true; MainRibbon.SelectedPage = MainRibbon.MergedPages.GetPageByText("VIEW"); MainRibbon.SelectedPage = MainRibbon.MergedPages.GetPageByName(ribbonPagePreview.Name); var reportControl = reportDesigner1.ActiveDesignPanel.GetService(typeof(DevExpress.XtraReports.Design.ReportTabControl)) as DevExpress.XtraReports.Design.ReportTabControl; if(reportControl == null || reportControl.PreviewControl == null) return; DevExpress.XtraBars.Docking.DockPanel navigationDockPanel = reportControl.PreviewControl.DockManager.Panels[new System.Guid("6b2e64eb-afd0-4676-bc3d-eca7e99946aa")]; if(navigationDockPanel != null) { navigationDockPanel.SavedDock = DevExpress.XtraBars.Docking.DockingStyle.Right; } return; } MainRibbon.SelectedPage = MainRibbon.MergedPages.GetPageByName(ribbonPagePreview.Name); }