public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PrintAllPlainteCrystalReport1 rpt = new PrintAllPlainteCrystalReport1();
rpt.Site = this.Site;
return(rpt);
}
private void PrintAllPlaintes_Load(object sender, EventArgs e)
{
try
{
PrintAllPlainteCrystalReport1 c = new PrintAllPlainteCrystalReport1();
PrintAllPlaintDataSet ds = new PrintAllPlaintDataSet();
SqlConnection cn = connection.getConnection();
string query = "select p.*,pl.nom from plaignant pl,plainte p where p.id_plaignant=pl.id_plaignant and p.etat='non archivé'";
SqlDataAdapter da = new SqlDataAdapter(query, cn);
da.Fill(ds, "plainte");
string query1 = "select top(1) * from avocat";
SqlDataAdapter da1 = new SqlDataAdapter(query1, cn);
da1.Fill(ds, "avocat");
c.SetDataSource(ds);
crystalReportViewer1.ReportSource = c;
crystalReportViewer1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace);
}
}