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