public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
DebtorListRPT rpt = new DebtorListRPT();
rpt.Site = this.Site;
return(rpt);
}
private void cmdDisplay2_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
dataSetReport = myReports.getDebtorList(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.SelectedValue.ToString());
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("DebtorList.xml");
DebtorListRPT myaclist = new DebtorListRPT();
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", cmbMonth.Text + " of " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
