public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
BelowNormListRPT rpt = new BelowNormListRPT();
rpt.Site = this.Site;
return(rpt);
}
private void btnBNormList_Click(object sender, EventArgs e)
{
try
{
DataSet dataSetReport = new DataSet();
if (chkAll.Checked)
{
dataSetReport = myReports.getBelowNormList(dtpFrom.Value.Date, dtpTo.Value.Date, "%");
}
else
{
dataSetReport = myReports.getBelowNormList(dtpFrom.Value.Date, dtpTo.Value.Date, cmbDivision.SelectedValue.ToString());
}
dataSetReport.WriteXml("BelowNormList.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
BelowNormListRPT myaclist = new BelowNormListRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", mydiv.ListEstates().Rows[0][0].ToString());
myaclist.SetParameterValue("Period", "From : " + dtpFrom.Value.Date + " To : " + dtpTo.Value.Date);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
