public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
allDepotPlainte rpt = new allDepotPlainte();
rpt.Site = this.Site;
return(rpt);
}
private void ImprimerAllDepotPlainte_Load(object sender, EventArgs e)
{
allDepotPlainte cr = new allDepotPlainte();
PrintAllDepotPlaintDataSet4 ds = new PrintAllDepotPlaintDataSet4();
SqlConnection cn = connection.getConnection();
String query1 = "select dc.id_depot,dc.id_plainte,cc.nom,ad.nom as[nom_adv],dc.num_check,dc.montant from depot_plgn dc,plaignant cc,par_plaignant ad where dc.id_par_plaignant=ad.id_par_plaignant and dc.id_plaignant=cc.id_plaignant";
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();
}
