public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
WagesCashWorkBreakDownRPT rpt = new WagesCashWorkBreakDownRPT();
rpt.Site = this.Site;
return(rpt);
}
private void btnCashBreakDown_Click(object sender, EventArgs e)
{
String strCrop = "%";
String strAllDiv = "%";
DateTime dtFrom = dtpFromDate.Value.Date;
DateTime dtTo = dtpToDate.Value.Date;
//if (chkAllCrops.Checked)
// strCrop = "%";
//else
// strCrop = cmbCropType.SelectedValue.ToString();
if (chkDivision.Checked)
{
strAllDiv = "%";
}
else
{
strAllDiv = cmbDivision.SelectedValue.ToString();
}
DataSet dsWagesRPT = myWage.GetCashWorkBreakDown(strAllDiv, strCrop, dtFrom, dtTo);
if (dsWagesRPT.Tables[0].Rows.Count > 0)
{
dsWagesRPT.WriteXml("CheckrollCashBreakDown.xml");
WagesCashWorkBreakDownRPT myReport1 = new WagesCashWorkBreakDownRPT();
myReport1.SetDataSource(dsWagesRPT);
ReportViewer myViewer = new ReportViewer();
myReport1.SetParameterValue("Date", "From:" + dtpFromDate.Value.Date.ToShortDateString() + " To:" + dtpToDate.Value.Date.ToShortDateString());
myReport1.SetParameterValue("Estate", myEstate.ListEstates().Rows[0][0].ToString());
myReport1.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
if (chkDivision.Checked)
{
myReport1.SetParameterValue("Division", "All Division");
}
else
{
myReport1.SetParameterValue("Division", "Division " + strAllDiv);
}
myReport1.SetParameterValue("Crop Type", "ALL");
myViewer.crystalReportViewer1.ReportSource = myReport1;
myViewer.Show();
}
}
