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

            rpt.Site = this.Site;
            return(rpt);
        }
        private void btnDivisionSummary_Click(object sender, EventArgs e)
        {
            DataSet ds          = new DataSet();
            String  strDivision = cmbDivision.SelectedValue.ToString();

            if (chkDivision.Checked)
            {
                strDivision = "%";
            }
            else
            {
                strDivision = cmbDivision.SelectedValue.ToString();
            }
            DateTime Fromdate = Convert.ToDateTime(dtpFromDate.Value.Date);
            DateTime Todate   = Convert.ToDateTime(dtpToDate.Value.Date);

            ds = myReports.GetDivisionWiseSummary(strDivision, Fromdate, Todate);
            if (ds.Tables[0].Rows.Count > 0)
            {
                ds.WriteXml("DivisionWiseSummary.xml");
                DivisionWiseSummaryRPT myReportViewe = new DivisionWiseSummaryRPT();
                myReportViewe.SetDataSource(ds);
                myReportViewe.SetParameterValue("Estate", "Estate:" + myEstate.ListEstates().Rows[0][0].ToString() + " / DivisionID:" + cmbDivision.SelectedValue.ToString());
                myReportViewe.SetParameterValue("Date", "From: " + Fromdate.ToShortDateString() + "  To: " + Todate.ToShortDateString());
                myReportViewe.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
                ReportViewer myReportViewer = new ReportViewer();
                myReportViewer.crystalReportViewer1.ReportSource = myReportViewe;
                myReportViewer.Show();
            }
            else
            {
                MessageBox.Show("No Data To Print", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }