public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport rpt = new CrystalReport();
rpt.Site = this.Site;
return(rpt);
}
public void BindReport(int devisN)
{
DatabaseDataSet ds = new DatabaseDataSet();
var table1 = ds.Produit;
var adp = new ProduitTableAdapter();
adp.Fill(table1);
DataView dv1 = new DataView(table1, $"DevisN={devisN}", "", DataViewRowState.CurrentRows);
var produits = dv1.ToTable();
var table3 = ds.Devis;
var adp3 = new DevisTableAdapter();
adp3.Fill(table3);
DataView dv3 = new DataView(table3, $"DevisN={devisN}", "", DataViewRowState.CurrentRows);
var devis = dv3.ToTable();
var table2 = ds.Client;
var adp2 = new ClientTableAdapter();
adp2.Fill(table2);
DataView dv2 = new DataView(table2, $"IdClient={devis.Rows[0]["IdClient"]}", "", DataViewRowState.CurrentRows);
var client = dv2.ToTable();
DataSet n_ds = new DataSet();
n_ds.Tables.Add(produits);
n_ds.Tables.Add(devis);
n_ds.Tables.Add(client);
CrystalReport cr = new CrystalReport();
cr.SetDataSource(n_ds);
this.crystalReportViewer.ReportSource = cr;
this.crystalReportViewer.RefreshReport();
}