protected void Page_Load(object sender, EventArgs e)
    {
        btnRevert.Attributes.Add("onclick", "return ChekOne();");
        lblMsg.Text = "";
        if (!IsPostBack)
        {//bind office name to ddlOffice
            DataSet           dsOfficeName = new DataSet();
            string            szCmpId      = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString();
            Bill_Sys_ReportBO objReport    = new Bill_Sys_ReportBO();
            dsOfficeName             = objReport.GetOfficeName(szCmpId);
            ddlOffice.DataSource     = dsOfficeName.Tables[0];
            ddlOffice.DataTextField  = "SZ_OFFICE";
            ddlOffice.DataValueField = "SZ_OFFICE_ID";
            ddlOffice.DataBind();
            ddlOffice.Items.Insert(0, "--select--");
            //bind gride
            DataSet dsOfficeName1 = new DataSet();
            dsOfficeName1 = objReport.GetReceived_Report(szCmpId, "", "", "", "--select--");


            #region " default viwe of grid sor by ascending order of date"
            DataView dv1;
            dv1      = dsOfficeName1.Tables[0].DefaultView;
            dv1.Sort = "DATE_OF_REFERRAL_PROC,PATIENT_NAME ASC";
            grdReceivedeport.DataSource = dv1;
            grdExel.DataSource          = dv1;
            Session["OfficeData"]       = dsOfficeName1;
            grdReceivedeport.DataBind();
            grdExel.DataBind();

            #endregion
            if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_CHART_NO != "1"))
            {
                grdReceivedeport.Columns[2].Visible = false;
                grdExel.Columns[2].Visible          = false;
            }
        }
    }