public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { BagReport rpt = new BagReport(); rpt.Site = this.Site; return(rpt); }
private void testReport_Load(object sender, EventArgs e) { DataTable table = new DataTable(); DataTable tableItem = new DataTable(); MySqlDataReader reader = null; MySqlDataReader readerItems = null; table.Columns.Add("Bag_id", typeof(int)); table.Columns.Add("DeptName", typeof(string)); table.Columns.Add("Date", typeof(DateTime)); table.Columns.Add("BagNo", typeof(int)); table.Columns.Add("Issued", typeof(bool)); table.Columns.Add("Place", typeof(string)); tableItem.Columns.Add("Item_id", typeof(int)); tableItem.Columns.Add("Bag_id", typeof(int)); tableItem.Columns.Add("Color", typeof(string)); tableItem.Columns.Add("Size", typeof(string)); tableItem.Columns.Add("Article", typeof(string)); try { reader = DBConnection.getData(qry); if (reader.HasRows) { while (reader.Read()) { Object o; try { o = reader.GetString("place"); } catch (Exception) { o = null; } if (o != null) { table.Rows.Add(reader.GetInt32("bag_id"), reader.GetString("deptName"), reader.GetDateTime("date"), reader.GetInt32("bagNo"), reader.GetBoolean("issued"), reader.GetString("place")); } else { table.Rows.Add(reader.GetInt32("bag_id"), reader.GetString("deptName"), reader.GetDateTime("date"), reader.GetInt32("bagNo"), reader.GetBoolean("issued"), " "); } int bag_id = reader.GetInt32("bag_id"); readerItems = DBConnection.getDataViaTmpConnection("select item_id, bag_id, color, size, article from item where bag_id=" + bag_id); if (readerItems.HasRows) { while (readerItems.Read()) { tableItem.Rows.Add(readerItems.GetString("item_id"), readerItems.GetString("bag_id"), readerItems.GetString("color"), readerItems.GetString("size"), readerItems.GetString("article")); } readerItems.Close(); DBConnection.closeTmpConnection(); } } reader.Close(); if (readerItems != null) { if (!readerItems.IsClosed) { readerItems.Close(); } } Report.BagReport rpt = new Report.BagReport(); rpt.Database.Tables["Bags"].SetDataSource(table); rpt.Database.Tables["Items"].SetDataSource(tableItem); crystalReportViewer1.ReportSource = null; crystalReportViewer1.ReportSource = rpt; } else { reader.Close(); if (readerItems != null) { if (!readerItems.IsClosed) { readerItems.Close(); } } MessageBox.Show("No records of this date!", "Bags picker by date", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { if (readerItems != null) { if (!readerItems.IsClosed) { readerItems.Close(); } } MessageBox.Show("No records of this date!\n" + ex.Message + "\n" + ex.StackTrace, "Bags picker by date", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }