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

            rpt.Site = this.Site;
            return(rpt);
        }
        private void button2_Click(object sender, EventArgs e)
        {
            string supCode = cmbSupplier.SelectedValue.ToString();

            if (chkSupplier.Checked)
            {
                supCode = "%";
            }

            String strAllDeductions = "%";

            if (!chkDeduction.Checked)
            {
                strAllDeductions = cmbDeductionCode.SelectedValue.ToString();
            }

            String strAllDeductionsGroup = "%";

            if (!chkAllGroup.Checked)
            {
                strAllDeductionsGroup = cmbDeductionGroup.SelectedValue.ToString();
            }

            String route = "%";

            if (!chkRoute.Checked)
            {
                route = cmbRoute.SelectedValue.ToString();
            }

            DataSet dataSet = objRpt.GetDeductionDetailReport(Convert.ToInt32(cmbYear.SelectedValue), Convert.ToInt32(cmbMonth.SelectedValue), route, supCode, strAllDeductionsGroup, strAllDeductions);

            dataSet.WriteXml("SuppliyerMonthDeductions.xml");
            SupplierWiseMonthDeductionRPT myReport = new SupplierWiseMonthDeductionRPT();

            myReport.SetDataSource(dataSet);

            myReport.SetParameterValue("Year", cmbYear.SelectedValue.ToString());
            myReport.SetParameterValue("Month", cmbMonth.Text);
            myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());

            if (chkDeduction.Checked == true)
            {
                myReport.SetParameterValue("Deduction", "All Deduction");
            }
            else
            {
                myReport.SetParameterValue("Deduction", cmbDeductionCode.Text);
            }

            if (chkRoute.Checked == true)
            {
                myReport.SetParameterValue("Route", "All Route");
            }
            else
            {
                myReport.SetParameterValue("Route", cmbRoute.Text);
            }

            ReportViewer rptViewer = new ReportViewer();

            rptViewer.crystalReportViewer1.ReportSource = myReport;
            rptViewer.Show();
        }