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

            rpt.Site = this.Site;
            return(rpt);
        }
        private void btnRPT2_Click(object sender, EventArgs e)
        {
            DataSet dataSetReport = new DataSet();

            try
            {
                String strDivision = "%";
                if (chkAll.Checked)
                {
                    strDivision = "%";
                }
                else
                {
                    strDivision = cmbDivision.SelectedValue.ToString();
                }
                cmbYear_SelectedIndexChanged(null, null);
                //dataSetReport.Tables.Add(HoliPay.GetHolidayPayData(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.SelectedValue.ToString())));
                dataSetReport = HoliPay.ListHolidaypayMandaysEarningsNotOffered(dtpFrom.Value.Date, dtpTo.Value.Date, strDivision);
                if (dataSetReport.Tables[0].Rows.Count > 0)
                {
                    dataSetReport.WriteXml("HolidaypayRPT2.xml");
                    HolidaypayRPT2 myHPData = new HolidaypayRPT2();
                    myHPData.SetDataSource(dataSetReport);
                    ReportViewer myReportViewer = new ReportViewer();

                    myHPData.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
                    myHPData.SetParameterValue("Division", EstDivBlock.ListEstates().Rows[0][0].ToString() + " / " + cmbDivision.SelectedValue.ToString());
                    myHPData.SetParameterValue("Year", cmbYear.SelectedValue.ToString());
                    myReportViewer.crystalReportViewer1.ReportSource = myHPData;
                    myReportViewer.Show();
                }
                else
                {
                    MessageBox.Show("No Data To Preview\r\nMay Be Holidaypay Data Already Confirmed");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error, " + ex.Message);
            }
        }