Exemple #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            ReporteDeVenta rpt = new ReporteDeVenta();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void llenareporte()
        {
            var da = new SqlDataAdapter();
            var ds = new dsTallerCr();

            string sqlEmployees = "select * from ventas where idventa=(select max(idventa) from ventas)";
            //string sqlProducts = "select * from Products";
            //string sqlCustomers = "select * from Customers";

            var cmd = new SqlCommand("", Conexion);

            cmd.CommandType = CommandType.Text;

            cmd.CommandText  = sqlEmployees;
            da.SelectCommand = cmd;
            da.Fill(ds.Tables["Ventas"]);


            //cmd.CommandText = sqlProducts;
            //da.SelectCommand = cmd;
            //da.Fill(ds.Tables["Products"]);

            //cmd.CommandText = sqlCustomers;
            //da.SelectCommand = cmd;
            //da.Fill(ds.Tables["Customers"]);


            var rptPractica61 = new ReporteDeVenta();

            rptPractica61.SetDataSource(ds);

            //rptPractica61.Subreports[0].SetDataSource(ds);

            this.crystalReportViewer1.ReportSource = rptPractica61;

            this.crystalReportViewer1.Show();
        }