示例#1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            SolicitudBaja rpt = new SolicitudBaja();

            rpt.Site = this.Site;
            return(rpt);
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            rprt.Load(Server.MapPath(@"~/Reports/SolicitudBaja.rpt"));
            rprt.FileName = Server.MapPath(@"~/Reports/SolicitudBaja.rpt");
            SqlConnection  con = new SqlConnection(@"Data Source=sql5037.site4now.net;Initial Catalog=DB_A26FD9_SICOESHunucma;User Id= DB_A26FD9_SICOESHunucma_admin;Password=sicoeshunucma2018;");
            SqlCommand     cmd = new SqlCommand("FormatoSolicitudBaja", con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            //cmd.Parameters.Add("@IDAlumno", SqlDbType.Int).Value = 33;
            //cmd.Parameters.Add("@IDDOCS", SqlDbType.Int).Value = 35;
            ConnectionInfo connectionInfo = new ConnectionInfo();

            connectionInfo.ServerName   = "sql5037.site4now.net";
            connectionInfo.DatabaseName = "DB_A26FD9_SICOESHunucma";
            connectionInfo.UserID       = "DB_A26FD9_SICOESHunucma_admin";
            connectionInfo.Password     = "******";
            SetDBLogonForReport(connectionInfo, rprt);
            int id = Convert.ToInt32(Session["SolicitudReporteID"]);

            rprt.SetParameterValue("@IDSolicitud", id);
            SolicitudBaja.ReportSource = rprt;
            SolicitudBaja.DataBind();
        }