public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
LoanRegisterRPT rpt = new LoanRegisterRPT();
rpt.Site = this.Site;
return(rpt);
}
private void cmdDisplay1_Click(object sender, EventArgs e)
{
try
{
DataSet dataSetReport = new DataSet();
dataSetReport = myReports.getLoanRegister(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("LoanRegister.xml");
LoanRegisterRPT myaclist = new LoanRegisterRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Period", "Month of " + cmbMonth.Text + "/" + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No data to preview");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}