public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PaymentCheckrollRPTII rpt = new PaymentCheckrollRPTII();
rpt.Site = this.Site;
return(rpt);
}
private void cmdDisplay2_Click(object sender, EventArgs e)
{
String AllCat = "%";
if (chkAllCat.Checked)
{
AllCat = "%";
}
else
{
AllCat = cmbEmpCat.SelectedValue.ToString();
}
try
{
if (chkAllDivisions.Checked == true)
{
dataSetReport = myReports.getPaymentCheckRollII(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), AllCat);
dataSetReport.WriteXml("PaymentCheckRollII.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
PaymentCheckrollRPTII myaclist = new PaymentCheckrollRPTII();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("paramDivision", "ALL");
myaclist.SetParameterValue("paramYearMonth", cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
else
{
dataSetReport = myReports.getPaymentCheckRollII(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), AllCat);
dataSetReport.WriteXml("PaymentCheckRollII.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
PaymentCheckrollRPTII myaclist = new PaymentCheckrollRPTII();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("paramDivision", cmbDivision.Text);
myaclist.SetParameterValue("paramYearMonth", cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}