public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { RepAllDepotOrder rpt = new RepAllDepotOrder(); rpt.Site = this.Site; return(rpt); }
private void ImprimerAllDepotOrder_Load(object sender, EventArgs e) { RepAllDepotOrder cr = new RepAllDepotOrder(); PrintAllDepotOrderDataSet4 ds = new PrintAllDepotOrderDataSet4(); SqlConnection cn = connection.getConnection(); String query1 = "select do.id_depot,do.id_order,co.nom,ao.nom as[nom_adv],do.num_check,do.montant from depot_order do,client_order co ,adv_order ao where co.id_client_order=do.id_client_order and ao.id_adv_order=do.id_adv_order"; SqlDataAdapter da = new SqlDataAdapter(query1, cn); da.Fill(ds, "Commande"); string query2 = "select top(1) * from avocat"; SqlDataAdapter da2 = new SqlDataAdapter(query2, cn); da2.Fill(ds, "avocat"); cr.SetDataSource(ds); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh(); }