public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { POM_Reports rpt = new POM_Reports(); rpt.Site = this.Site; return(rpt); }
public void GetPOID(string nofilter, string CostCode, string Item_Code, string ProjectCode, string ReportTypeID, DateTime DateFrom, DateTime DateTo, string ForPurchase) { SqlConnection con = new SqlConnection(conStr); SqlDataAdapter sda = new SqlDataAdapter("POM_REPORT " + nofilter + "," + Item_Code + "," + CostCode + "," + ProjectCode + "," + ReportTypeID + ",'" + DateFrom + "','" + DateTo + "'," + ForPurchase, con); DataSet ds = new DataSet(); sda.Fill(ds); ds.Tables[0].TableName = "POMList"; POM_Reports bill = new POM_Reports(); bill.SetDataSource(ds); bill.VerifyDatabase(); crystalReportViewer1.ReportSource = bill; crystalReportViewer1.RefreshReport(); }