public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            CrystalReport2 rpt = new CrystalReport2();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void Form_product_report_Load(object sender, EventArgs e)
        {
            CrystalReport2 s = new CrystalReport2();

            DataTable            table = new DataTable();
            List <Products_DATA> list  = Products_DAL.Select_ALL_Product();

            table.Columns.Add("Id");
            table.Columns.Add("label_product");
            table.Columns.Add("qte_in_product");
            table.Columns.Add("price");


            table.Columns.Add("image", typeof(byte[]));
            table.Columns.Add("category_FK");
            table.Columns.Add("description");

            foreach (var item in list)
            {
                //table.Rows.Add(item.Id, item.Label_product, item.Price, item.Qte_in_product, item.Category.Description, item.Category.Id, item.Image);
                table.Rows.Add(item.Id, item.Label_product, item.Qte_in_product, item.Price, item.Image, item.Category.Id, item.Category.Description);
            }



            s.SetDataSource(table);
            crystalReportViewer1.ReportSource = s;
        }