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

            rpt.Site = this.Site;
            return(rpt);
        }
        private void bayElementReportForm_Load(object sender, EventArgs e)
        {
            MySqlConnection con = new MySqlConnection(myInfo.ConStr);
            string          sql = "SELECT elements.NameElement,elements.Type,bayelement.price,bayelement.Quantity,baylists.IDBay,baylists.ListNo,baylists.ListDate,shopes.NameShope,bayelement.Price*bayelement.Quantity as total FROM elements inner join bayelement on elements.IDElement = bayelement.IDElement inner join baylists ON bayelement.IDBay= baylists.IDBay inner join shopes on baylists.IDShope = shopes.IDShope where elements.IDElement= " + ElementID + " order by baylists.ListDate;";

            //end of sql statment
            using (con)
            {
                bayElementReporDataSet ds      = new bayElementReporDataSet();
                MySqlDataAdapter       adapter = new MySqlDataAdapter(sql, con);
                adapter.Fill(ds.Tables["DataTable1"]);
                //adapter.Fill(ds.DataTable1);
                bayElementCrystalReport report = new bayElementCrystalReport();
                report.SetDataSource(ds.Tables["DataTable1"]);
                //for (int i =0; i < ds.DataTable1.Rows.Count; i++) { MessageBox.Show(ds.DataTable1[i][10].ToString); }
                crystalReportViewer1.ReportSource = report;
                crystalReportViewer1.Refresh();
            }
        }