public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { DeliveryCrystalReport rpt = new DeliveryCrystalReport(); rpt.Site = this.Site; return(rpt); }
void DeliveryReportMethod() { try { SqlDataAdapter daR1 = new SqlDataAdapter("SELECT * FROM Delivery_Table WHERE Date BETWEEN '" + dateFrom + "' AND '" + dateTo + "'", con); con.Open(); DataSet dsR1 = new DataSet(); daR1.Fill(dsR1, "Delivery_Table"); MessageBox.Show(dsR1.Tables["Delivery_Table"].Rows.Count.ToString()); if (dsR1.Tables["Delivery_Table"].Rows.Count == 0) { MessageBox.Show("No data found!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } con.Close(); DeliveryCrystalReport objDelRpt = new DeliveryCrystalReport(); objDelRpt.SetDatabaseLogon("genesip", "genesip"); objDelRpt.SetDataSource(dsR1.Tables["Delivery_Table"]); crystalReportViewer1.ReportSource = objDelRpt; crystalReportViewer1.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }