protected void Page_Load(object sender, EventArgs e)
    {
        if (WebFactory.Validate(Session.SessionID))
        {
            WebSession obj = WebFactory.GetUser(Session.SessionID);
            if (obj.GetRole.ToLower().Trim() == "user")
            {
                if (!IsPostBack)
                {

               a = new CrystalDecisions.Web.CrystalReportSource();
               a.Report.FileName = Server.MapPath("crystalreports/urine_cr_graph.rpt");

               //Response.Write(Server.MapPath("crystalreports/blood_CrystalReport.rpt"));

               a.ReportDocument.SetDatabaseLogon("sa", "sa", ".", "health");
               a.ReportDocument.SetParameterValue("abc", obj.GetUserid.ToString());
               CrystalReportViewer1.ReportSource = a;

                }
            }
            else
            {
                Response.Redirect("/Totalhealth/msgpage.aspx");
            }

        }
        else
        {
            Response.Redirect("/Totalhealth/loginpage.aspx");

        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        a = new CrystalDecisions.Web.CrystalReportSource();
               a.Report.FileName = Server.MapPath("crystalreports/pie_statewise_bgroup.rpt");

               //Response.Write(Server.MapPath("crystalreports/blood_CrystalReport.rpt"));

               a.ReportDocument.SetDatabaseLogon("sa", "sa", ".", "health");
              // a.ReportDocument.SetParameterValue("abc", obj.GetUserid.ToString());
               CrystalReportViewer1.ReportSource = a;
    }