public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rep_depot_cause rpt = new rep_depot_cause();
rpt.Site = this.Site;
return(rpt);
}
private void Imprimer_Depot_Cause_Load(object sender, EventArgs e)
{
rep_depot_cause cr = new rep_depot_cause();
//cr.SetParameterValue("id", id);
//crystalReportViewer1.ReportSource = cr;
//crystalReportViewer1.Refresh();
SqlConnection cn = connection.getConnection();
PrintAllDepotCauseDataSet4 ds = new PrintAllDepotCauseDataSet4();
String query1 = "select dp.id_depot,dp.id_cause,cc.nom,ad.nom_adv,dp.num_check,dp.montant from depot_cause dp,adversaire_cause ad,client_cause cc where dp.id_depot like '" + id + "' and cc.id_client_cause=dp.id_client_cause and dp.id_adversaire_cause=ad.id_adversaire_cause";
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();
}