public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { MRM_Report rpt = new MRM_Report(); rpt.Site = this.Site; return(rpt); }
public void GetMaterialReport(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("MRM_REPORT " + nofilter + "," + Item_Code + "," + CostCode + "," + ProjectCode + "," + ReportTypeID + ",'" + DateFrom + "','" + DateTo + "'," + ForPurchase, con); DataSet ds = new DataSet(); sda.Fill(ds); ds.Tables[0].TableName = "MRMList"; MRM_Report bill = new MRM_Report(); bill.SetDataSource(ds); bill.VerifyDatabase(); crystalReportViewer1.ReportSource = bill; crystalReportViewer1.RefreshReport(); }