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