public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptCommissionStatement rpt = new rptCommissionStatement();
rpt.Site = this.Site;
return(rpt);
}
private void btnPrint_Click(object sender, EventArgs e)
{
if (cmb_commission_id.EditValue == null || cmb_commission_id.EditValue.ToString() == "")
{
XtraMessageBox.Show("Please select a valid commission ID");
cmb_commission_id.Focus();
return;
}
this.Cursor = Cursors.WaitCursor;
dsCommission ds = new dsCommission();
DataSet dsSP = bllReports.CommissionStatement(cmb_account_holder.EditValue.ToString(), cmb_commission_id.EditValue.ToString());
try
{
foreach (DataRow dr in dsSP.Tables[0].Rows)
{
ds.Tables["CommissionDetails"].ImportRow(dr);
}
foreach (DataRow dr in dsSP.Tables[1].Rows)
{
ds.Tables["CommissionSummary"].ImportRow(dr);
}
foreach (DataRow dr in bllCompanyInfo.getById(1).Rows)
{
ds.Tables["CompanyInfo"].ImportRow(dr);
}
rptCommissionStatement rptTest = new Report.rptCommissionStatement();
rptTest.SetDataSource(ds);
//rptTest.SetParameterValue("SalesReturn", bllUtility.Val("0"));
frmPrint ifrmPrint = new frmPrint(rptTest);
ifrmPrint.Visible = true;
}
catch
{
this.Cursor = Cursors.Default;
}
this.Cursor = Cursors.Default;
}
