public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
SupplierIncentiveDetailsRPT rpt = new SupplierIncentiveDetailsRPT();
rpt.Site = this.Site;
return(rpt);
}
private void btnIncentiveSummary_Click(object sender, EventArgs e)
{
DataTable dataSetReport = new DataTable();
dataSetReport.TableName = "SupplierIncentiveDetails";
BoughtLeafBusinessLayer.MothlyPaymentSummary myMonthlySummary = new BoughtLeafBusinessLayer.MothlyPaymentSummary();
string supRoute = "%";
if (!chkRoute.Checked)
{
supRoute = cmbRoute.SelectedValue.ToString();
}
string supCode = string.Empty;
if (chkSupplier.Checked == true)
{
supCode = "%";
}
else
{
supCode = cmbSupplier.SelectedValue.ToString();
}
dataSetReport = myMonthlySummary.getSupplierIncentiveDetail(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), supCode, supRoute).Tables[0];
dataSetReport.WriteXml("SupplierIncentiveDetails.xml");
SupplierIncentiveDetailsRPT myReport = new SupplierIncentiveDetailsRPT();
myReport.SetDataSource(dataSetReport);
ReportViewer rptViewer = new ReportViewer();
myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myReport.SetParameterValue("Year", cmbYear.Text);
myReport.SetParameterValue("Month", cmbMonth.SelectedValue.ToString());
myReport.SetParameterValue("payRate", mySettings.getKiloRate(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue)));
rptViewer.crystalReportViewer1.ReportSource = myReport;
rptViewer.Show();
}
