public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
agrREPORT rpt = new agrREPORT();
rpt.Site = this.Site;
return(rpt);
}
private void FrReport_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(connectionString);
try
{
conn.Open();
DataTable dt = new DataTable();
string sql = "SELECT AGR_ID,AGR_Name,DESCRIP,LOC_ID,Shop_ID,amount,unit,price,AGR_Type FROM AGRICULTURAL WHERE Shop_ID ='" + this.shop_ID + "'";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(dt);
agrREPORT rp = new agrREPORT();
rp.SetDataSource(dt);
this.cryReportViewer.ReportSource = rp;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
conn.Close();
}
}
