Esempio n. 1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            rep_depot_cause rpt = new rep_depot_cause();

            rpt.Site = this.Site;
            return(rpt);
        }
Esempio n. 2
0
        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();
        }