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);
}
}
