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();
}
