public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
EmployeeWisePaymentDetailsRPT rpt = new EmployeeWisePaymentDetailsRPT();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
String strParamDiv = "All Division";
String strParamEmp = "All Employees";
String strEmployee = "%";
String strDivision = "%";
if (!chkAllDivisions.Checked)
{
strDivision = cmbDivision.SelectedValue.ToString();
strParamDiv = cmbDivision.SelectedValue.ToString();
}
if (!chkAllEmp.Checked)
{
strEmployee = cmbEmpNo.SelectedValue.ToString();
strParamEmp = cmbEmpNo.SelectedValue.ToString();
}
DataSet ds = new DataSet();
//dt = myRep.GetAmalgamation(cmbYear.Text, month);
ds = myReports.PaymentDetailsSummaryEmpwise(strDivision, dtpFrom.Value.Date, dtpTo.Value.Date, strEmployee);
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("PaymentDetailsSummaryEmpwise.xml");
//PaymentDetailsSummaryEmpRPTrpt myReport = new PaymentDetailsSummaryEmpRPTrpt();
EmployeeWisePaymentDetailsRPT myReport = new EmployeeWisePaymentDetailsRPT();
myReport.SetDataSource(ds);
ReportViewer myViewer = new ReportViewer();
myReport.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
if (chkAllDivisions.Checked)
{
myReport.SetParameterValue("Estate", "Estate :" + myDiv.ListEstates().Rows[0][0].ToString() + " - Division:" + strParamDiv);
}
else
{
myReport.SetParameterValue("Estate", "Estate :" + myDiv.ListEstates().Rows[0][0].ToString() + " - Division:" + myDiv.GetDivisionNameByID(strParamDiv));
}
myReport.SetParameterValue("Period", "From:" + dtpFrom.Value.Date.ToShortDateString() + " To:" + dtpTo.Value.Date.ToShortDateString());
myViewer.crystalReportViewer1.ReportSource = myReport;
myViewer.Show();
}
else
{
MessageBox.Show("No Data Preview..!");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Occurred..!" + ex.Message);
}
}
