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