public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { PrintAllOrdersReport rpt = new PrintAllOrdersReport(); rpt.Site = this.Site; return(rpt); }
private void PrintAllOrdersForm_Load(object sender, EventArgs e) { DataSet2 ds = new DataSet2(); PrintAllOrdersReport cr = new PrintAllOrdersReport(); SqlConnection cn = connection.getConnection(); String query1 = "select o.id_order,o.signe_order,o.date_order,o.commissaire_judiciaire,o.ville,o.tribunal,c.nom as 'id_client_order',a.nom as 'id_adversaire_order',o.decision,o.type from orderr o,adv_order a,client_order c where o.id_adversaire_order=a.id_adv_order and o.id_client_order=c.id_client_order"; SqlDataAdapter da = new SqlDataAdapter(query1, cn); da.Fill(ds, "orderr"); string query2 = "select nom_avocat,adresse,autorite from avocat"; SqlDataAdapter da2 = new SqlDataAdapter(query2, cn); da2.Fill(ds, "avocat"); cr.SetDataSource(ds); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh(); }