public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            GuaranteeRecoveryRPT rpt = new GuaranteeRecoveryRPT();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void cmdDisplay2_Click(object sender, EventArgs e)
        {
            DataSet ds = myGuarantee.GetGuaranteeRecoveryList(cmbDivision.Text, cmbYear.Text, cmbMonth.SelectedValue.ToString());

            if (ds.Tables[0].Rows.Count > 0)
            {
                ds.WriteXml("GuaranteeRecovery.xml");

                GuaranteeRecoveryRPT myRPT = new GuaranteeRecoveryRPT();
                myRPT.SetDataSource(ds);
                myRPT.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
                myRPT.SetParameterValue("Division", "DivisionID : " + cmbDivision.Text);
                myRPT.SetParameterValue("Period", "Period : " + cmbYear.Text + " - " + cmbMonth.Text);

                ReportViewer myViewer = new ReportViewer();
                myViewer.crystalReportViewer1.ReportSource      = myRPT;
                myViewer.crystalReportViewer1.ShowRefreshButton = false;
                myViewer.Show();
            }
            else
            {
                MessageBox.Show("No data to preview..!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }