public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { costCrystalReport3 rpt = new costCrystalReport3(); rpt.Site = this.Site; return(rpt); }
private void costReportForm_Load(object sender, EventArgs e) { costCrystalReport3 report = new costCrystalReport3(); costDataSet ds = new costDataSet(); MySqlConnection con = new MySqlConnection(myInfo.ConStr); //string sql = "SELECT items.IDItem,items.NameItem FROM madatec.items;"; string sqlItemsElements = "SELECT items.IDItem,items.NameItem,elements.NameElement,elements.IDElement,itemelement.Quantity from items inner join itemelement on items.IDItem = itemelement.IDItem inner join elements on itemelement.IDElement= elements.IDElement where items.IDItem = " + ItemID + ";"; //end of sql statment using (con) { MySqlDataAdapter adapter = new MySqlDataAdapter(sqlItemsElements, con); adapter.Fill(ds.Tables["DataTable1"]); //adapter.Fill(ds.DataTable1); report.SetDataSource(ds.Tables["DataTable1"]); } //DataTable dt = ds.DataTable1; foreach (DataRow row in ds.DataTable1) { //MessageBox.Show(Convert.ToString(row["Quantity"])); double quantity = Convert.ToDouble(row["Quantity"]); double price = myInfo.FindElementPrice(Convert.ToInt32(row["IDElement"]), System.DateTime.Today.Year, System.DateTime.Today.Month); double priceAvereg = quantity * price; row["PriceAvereg"] = priceAvereg; } //foreach (DataRow row in ds.DataTable1) { // MessageBox.Show(row["PriceAvereg"].ToString()); //} //for (int i =0; i < ds.DataTable1.Rows.Count; i++) { MessageBox.Show(ds.DataTable1[i][10].ToString); } report.SetDataSource(ds.Tables["DataTable1"]); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); //this.reportViewer1.RefreshReport(); }