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

            rpt.Site = this.Site;
            return(rpt);
        }
        private void btnShow_Click(object sender, EventArgs e)
        {
            Broker_Comission_Report_DSE_24_1BAL   objBAL = new Broker_Comission_Report_DSE_24_1BAL();
            crrptBroker_Comission_Report_DSE_24_1 objRPT = new crrptBroker_Comission_Report_DSE_24_1();
            frmReportViewer Viewer = new frmReportViewer();
            DataTable       dt     = new DataTable();

            Start_date     = dtpStart.Value;
            End_date       = dtpEnd.Value;
            Branch         = cmbbranch.Text;
            Exchange       = cmbexchange.Text;
            Trader         = cmbtrader.Text;
            Selection_type = cmbselection.Text;
            if (Selection_type == "All")
            {
                Exchange = "";
                Trader   = "";
                dt       = objBAL.Broker_Comission(Start_date, End_date, Exchange, Trader, Selection_type);
                objRPT.SetDataSource(dt);
                Viewer.crvReportViewer.ReportSource = objRPT;
                Exchange = "All";
                ((TextObject)objRPT.Section2.ReportObjects["txtStartDate"]).Text = Start_date.ToString("dd-MMMM-yyyy");
                ((TextObject)objRPT.Section2.ReportObjects["txtEndDate"]).Text   = End_date.ToString("dd-MMMM-yyyy");
                ((TextObject)objRPT.Section2.ReportObjects["txtBranch"]).Text    = Branch;
                ((TextObject)objRPT.Section2.ReportObjects["txtexchange"]).Text  = Exchange;
                ((TextObject)objRPT.Section2.ReportObjects["txtTrader"]).Text    = Trader;
                Viewer.Show();
            }
            else if (Selection_type == "Exchange")
            {
                if (cmbexchange.Text == "CSE")
                {
                }
                else
                {
                    Selection_type = "";
                    Branch         = "";
                    Exchange       = "";
                    dt             = objBAL.Broker_Comission_Trade(Start_date, End_date, Exchange, Branch, Selection_type);
                    objRPT.SetDataSource(dt);
                }
                Branch = "All";
                Trader = "All";
                if (Exchange == "DSE")
                {
                    Exchange = "DSE";
                }
                else if (Exchange == "CSE")
                {
                    Exchange = "CSE";
                }
                else
                {
                    Exchange = "All";
                }
                Viewer.crvReportViewer.ReportSource = objRPT;
                ((TextObject)objRPT.Section2.ReportObjects["txtStartDate"]).Text = Start_date.ToString("dd-MMMM-yyyy");
                ((TextObject)objRPT.Section2.ReportObjects["txtEndDate"]).Text   = End_date.ToString("dd-MMMM-yyyy");
                ((TextObject)objRPT.Section2.ReportObjects["txtBranch"]).Text    = Branch;
                ((TextObject)objRPT.Section2.ReportObjects["txtexchange"]).Text  = Exchange;
                ((TextObject)objRPT.Section2.ReportObjects["txtTrader"]).Text    = Trader;
                Viewer.Show();
            }
            else if (Selection_type == "Branch")
            {
                Exchange = "DSE";
                dt       = objBAL.Broker_Comission_Trade(Start_date, End_date, Exchange, Branch, Selection_type);
                objRPT.SetDataSource(dt);
                Viewer.crvReportViewer.ReportSource = objRPT;
                Trader   = "All";
                Exchange = "All";
                ((TextObject)objRPT.Section2.ReportObjects["txtStartDate"]).Text = Start_date.ToString("dd-MMMM-yyyy");
                ((TextObject)objRPT.Section2.ReportObjects["txtEndDate"]).Text   = End_date.ToString("dd-MMMM-yyyy");
                ((TextObject)objRPT.Section2.ReportObjects["txtBranch"]).Text    = Branch;
                ((TextObject)objRPT.Section2.ReportObjects["txtexchange"]).Text  = Exchange;
                ((TextObject)objRPT.Section2.ReportObjects["txtTrader"]).Text    = Trader;
                Viewer.Show();
            }
            else if (Selection_type == "Trader")
            {
                Exchange = "DSE";
                dt       = objBAL.Broker_Comission_Trade(Start_date, End_date, Exchange, Trader, Selection_type);
                objRPT.SetDataSource(dt);
                Viewer.crvReportViewer.ReportSource = objRPT;
                Exchange = "All";
                Branch   = "All";
                ((TextObject)objRPT.Section2.ReportObjects["txtStartDate"]).Text = Start_date.ToString("dd-MMMM-yyyy");
                ((TextObject)objRPT.Section2.ReportObjects["txtEndDate"]).Text   = End_date.ToString("dd-MMMM-yyyy");
                ((TextObject)objRPT.Section2.ReportObjects["txtBranch"]).Text    = Branch;
                ((TextObject)objRPT.Section2.ReportObjects["txtexchange"]).Text  = Exchange;
                ((TextObject)objRPT.Section2.ReportObjects["txtTrader"]).Text    = Trader;
                Viewer.Show();
            }
        }