public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
FieldWiseNormUpdateLogRPT rpt = new FieldWiseNormUpdateLogRPT();
rpt.Site = this.Site;
return(rpt);
}
private void btnNormUpdateLog_Click(object sender, EventArgs e)
{
String strTextToSearch = "";
if (String.IsNullOrEmpty(txtFieldIDToSearch.Text))
{
strTextToSearch = "";
}
else
{
strTextToSearch = txtFieldIDToSearch.Text;
}
DataTable dsDivisionReport = new DataTable();
//dsDivisionReport = myEmployeeDeduction.GetMonthPRINorms(cmbDivision.SelectedValue.ToString(), new DateTime(dateTimePicker1.Value.Date.Year, dateTimePicker1.Value.Date.Month, 1), new DateTime(dateTimePicker1.Value.Date.Year, dateTimePicker1.Value.Date.Month, 1).AddMonths(1).AddDays(-1)).Tables[0];
dsDivisionReport = DivNorm.GetFieldNormUpdateLog(Convert.ToDateTime(dateTimePicker1.Value.Date.ToShortDateString()), cmbDivision.SelectedValue.ToString(), cmbCropType.Text, strTextToSearch).Tables[0];
if (dsDivisionReport.Rows.Count > 0)
{
dsDivisionReport.WriteXml("MonthPRINormUpdateLog.xml");
FieldWiseNormUpdateLogRPT objReport = new FieldWiseNormUpdateLogRPT();
objReport.SetDataSource(dsDivisionReport);
ReportViewerForm objReportViewer = new ReportViewerForm();
objReport.SetParameterValue("Estate", EstDiv.ListEstates().Rows[0][0].ToString());
objReport.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
objReport.SetParameterValue("Division", cmbDivision.SelectedValue.ToString());
objReport.SetParameterValue("Period", dateTimePicker1.Value.Date.ToShortDateString());
objReport.SetParameterValue("UserId", FTSPayRollBL.User.StrUserName);
objReportViewer.crystalReportViewer1.ReportSource = objReport;
objReportViewer.Show();
}
else
{
MessageBox.Show("No Data To Preview.");
}
}
