public void Fill(object sender, EventArgs e) { //app_branch app_branch = cbxBranch.SelectedItem as app_branch; //if (app_branch != null) //{ this.reportViewer.Reset(); Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); Data.SalesDS SalesDB = new Data.SalesDS(); SalesDB.BeginInit(); Data.SalesDSTableAdapters.DeliveryByZoneTableAdapter DeliveryByZoneTableAdapter = new Data.SalesDSTableAdapters.DeliveryByZoneTableAdapter(); DataTable dt = DeliveryByZoneTableAdapter.GetData(StartDate, StartDate, CurrentSession.Id_Company, smtgeo.GeographyID); reportDataSource1.Name = " DeliveryByZone"; //Name of the report dataset in our .RDLC file reportDataSource1.Value = dt; //SalesDB.SalesByDate; this.reportViewer.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports. DeliveryByZone.rdlc"; SalesDB.EndInit(); this.reportViewer.Refresh(); this.reportViewer.RefreshReport(); //} }
public void Fill(object sender, EventArgs e) { this.reportViewer.Reset(); Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); Data.SalesDS SalesDB = new Data.SalesDS(); SalesDB.BeginInit(); Data.SalesDSTableAdapters.SalesByVATTableAdapter SalesByVATTableAdapter = new Data.SalesDSTableAdapters.SalesByVATTableAdapter(); //fill data SalesByVATTableAdapter.ClearBeforeFill = true; DataTable dt = new DataTable(); dt = SalesByVATTableAdapter.GetDataByDate(StartDate, EndDate, CurrentSession.Id_Company); reportDataSource1.Name = "SalesByVAT"; //Name of the report dataset in our .RDLC file reportDataSource1.Value = dt; this.reportViewer.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.SalesByVAT.rdlc"; SalesDB.EndInit(); this.reportViewer.Refresh(); this.reportViewer.RefreshReport(); }
public void Fill(object sender, EventArgs e) { this.reportViewer.Reset(); Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); Data.SalesDS SalesDB = new Data.SalesDS(); SalesDB.BeginInit(); Data.SalesDSTableAdapters.SalesByItemTableAdapter SalesByItemTableAdapter = new Data.SalesDSTableAdapters.SalesByItemTableAdapter(); //fill data SalesByItemTableAdapter.ClearBeforeFill = true; DataTable dt = new DataTable(); if (ReportPanel.Branch != null) { dt = SalesByItemTableAdapter.GetDataByBranch(ReportPanel.StartDate, ReportPanel.EndDate, ReportPanel.Branch.id_branch, CurrentSession.Id_Company); } else { dt = SalesByItemTableAdapter.GetDataByGeneral(ReportPanel.StartDate, ReportPanel.EndDate, CurrentSession.Id_Company); } reportDataSource1.Name = "SalesByItem"; //Name of the report dataset in our .RDLC file reportDataSource1.Value = dt; this.reportViewer.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.SalesByItem.rdlc"; SalesDB.EndInit(); this.reportViewer.Refresh(); this.reportViewer.RefreshReport(); }
public void Fill(object sender, RoutedEventArgs e) { this.reportViewer.Reset(); Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); Data.SalesDS SalesDB = new Data.SalesDS(); SalesDB.BeginInit(); Data.SalesDSTableAdapters.SalesBudgetSummaryTableAdapter SalesBudgetSummaryTableAdapter = new Data.SalesDSTableAdapters.SalesBudgetSummaryTableAdapter(); DataTable dt = new DataTable(); if (ReportPanel.Branch != null) { dt = SalesBudgetSummaryTableAdapter.GetDataByBranch(ReportPanel.StartDate, ReportPanel.EndDate, ReportPanel.Branch.id_branch); } else { dt = SalesBudgetSummaryTableAdapter.GetDataBy(ReportPanel.StartDate, ReportPanel.EndDate); } //ReportParameter[] parameters = new ReportParameter[x+1]; reportDataSource1.Name = "SalesBudgetSummary"; //Name of the report dataset in our .RDLC file reportDataSource1.Value = dt; //SalesDB.SalesByDate; this.reportViewer.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.SalesBudgetSummary.rdlc"; //parameters[0] = new ReportParameter("name1", value1); //parameters[0] = new ReportParameter("name1", value1); //parameters[0] = new ReportParameter("name1", value1); //parameters[0] = new ReportParameter("name1", value1); //parameters[0] = new ReportParameter("name1", value1); //this.reportViewer.LocalReport.SetParameters("EndDate", dtEndDate, false); SalesDB.EndInit(); this.reportViewer.Refresh(); this.reportViewer.RefreshReport(); }
public void Fill(object sender, EventArgs e) { this.reportViewer.Reset(); Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); Data.SalesDS SalesDB = new Data.SalesDS(); SalesDB.BeginInit(); Data.SalesDSTableAdapters.SalesReturnDetailTableAdapter SalesReturnDetailTableAdapter = new Data.SalesDSTableAdapters.SalesReturnDetailTableAdapter(); DataTable dt = SalesReturnDetailTableAdapter.GetData(ReportPanel.StartDate, ReportPanel.EndDate); reportDataSource1.Name = "SalesReturnDetail"; //Name of the report dataset in our .RDLC file reportDataSource1.Value = dt; //SalesDB.SalesByDate; this.reportViewer.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.SalesReturnDetail.rdlc"; SalesDB.EndInit(); this.reportViewer.Refresh(); this.reportViewer.RefreshReport(); }
public void Fill(object sender, EventArgs e) { this.reportViewer.Reset(); Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); Data.SalesDS SalesDB = new Data.SalesDS(); SalesDB.BeginInit(); reportDataSource1.Name = "CostOfGoodsSold"; //Name of the report dataset in our .RDLC file reportDataSource1.Value = SalesDB.CostOfGoodsSold; this.reportViewer.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.CostOfGoodsSold.rdlc"; SalesDB.EndInit(); //fill data Data.SalesDSTableAdapters.CostOfGoodsSoldTableAdapter CostOfGoodsSoldTableAdapter = new Data.SalesDSTableAdapters.CostOfGoodsSoldTableAdapter(); CostOfGoodsSoldTableAdapter.ClearBeforeFill = true; CostOfGoodsSoldTableAdapter.Fill(SalesDB.CostOfGoodsSold, ReportPanel.StartDate, ReportPanel.EndDate, entity.CurrentSession.Id_Company); this.reportViewer.RefreshReport(); }
public void Fill(object sender, EventArgs e) { this.reportViewer.Reset(); Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); Data.SalesDS SalesDB = new Data.SalesDS(); SalesDB.BeginInit(); reportDataSource1.Name = "CustomerList"; //Name of the report dataset in our .RDLC file reportDataSource1.Value = SalesDB.CustomerList; this.reportViewer.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.CustomerList.rdlc"; SalesDB.EndInit(); //fill data Data.SalesDSTableAdapters.CustomerListTableAdapter CustomerListTableAdapter = new Data.SalesDSTableAdapters.CustomerListTableAdapter(); CustomerListTableAdapter.ClearBeforeFill = true; CustomerListTableAdapter.Fill(SalesDB.CustomerList, IsCustomer, IsSupplier); this.reportViewer.RefreshReport(); }
public void Fill(object sender, RoutedEventArgs e) { this.reportViewer.Reset(); Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); Data.SalesDS SalesDB = new Data.SalesDS(); SalesDB.BeginInit(); Data.SalesDSTableAdapters.SalesInvoiceSummaryTableAdapter SalesInvoiceSummaryTableAdapter = new Data.SalesDSTableAdapters.SalesInvoiceSummaryTableAdapter(); DataTable dt = new DataTable(); if (ReportPanel.Branch != null) { dt = SalesInvoiceSummaryTableAdapter.GetDataByBranch(ReportPanel.StartDate, ReportPanel.EndDate, ReportPanel.Branch.id_branch); } else { dt = SalesInvoiceSummaryTableAdapter.GetDataBy(ReportPanel.StartDate, ReportPanel.EndDate); } if (ReportColumnsList.Count() == 0) { foreach (DataColumn item in dt.Columns) { if (ReportColumnsList.Where(x => x.Columname == item.ColumnName).Count() == 0) { if (item.ColumnName == "VAT_SubTotal" || item.ColumnName == "Profit" || item.ColumnName == "MarkUp" || item.ColumnName == "Margin" || item.ColumnName == "SubTotalCost" || item.ColumnName == "SubTotalVAT") { cntrl.ReportColumns ReportColumns = new cntrl.ReportColumns(); ReportColumns.Columname = item.ColumnName; ReportColumns.IsVisibility = true; ReportColumnsList.Add(ReportColumns); } } } ReportPanel.ReportColumn = ReportColumnsList; } reportDataSource1.Name = "SalesInvoiceSummary"; //Name of the report dataset in our .RDLC file reportDataSource1.Value = dt; //SalesDB.SalesByDate; this.reportViewer.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.SalesInvoiceSummary.rdlc"; foreach (cntrl.ReportColumns ReportColumns in ReportColumnsList) { if (ReportColumns.Columname == "VAT_SubTotal") { this.reportViewer.LocalReport.SetParameters(new ReportParameter("ShowVAT", ReportColumns.IsVisibility == null ? true.ToString() : ReportColumns.IsVisibility.ToString())); } if (ReportColumns.Columname == "Profit") { this.reportViewer.LocalReport.SetParameters(new ReportParameter("ShowProfit", ReportColumns.IsVisibility == null ? true.ToString() : ReportColumns.IsVisibility.ToString())); } if (ReportColumns.Columname == "MarkUp") { this.reportViewer.LocalReport.SetParameters(new ReportParameter("ShowMarkup", ReportColumns.IsVisibility == null ? true.ToString() : ReportColumns.IsVisibility.ToString())); } if (ReportColumns.Columname == "Margin") { this.reportViewer.LocalReport.SetParameters(new ReportParameter("ShowMargin", ReportColumns.IsVisibility == null ? true.ToString() : ReportColumns.IsVisibility.ToString())); } if (ReportColumns.Columname == "SubTotalCost") { this.reportViewer.LocalReport.SetParameters(new ReportParameter("ShowCost", ReportColumns.IsVisibility == null ? true.ToString() : ReportColumns.IsVisibility.ToString())); } if (ReportColumns.Columname == "SubTotalVAT") { this.reportViewer.LocalReport.SetParameters(new ReportParameter("ShowVATTotal", ReportColumns.IsVisibility == null ? true.ToString() : ReportColumns.IsVisibility.ToString())); } } SalesDB.EndInit(); this.reportViewer.Refresh(); this.reportViewer.RefreshReport(); }