public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptCurrentInventory rpt = new RptCurrentInventory();
rpt.Site = this.Site;
return(rpt);
}
// genarate Current Inventory report
public static ReportClass CurrentInventory()
{
OdbcDataAdapter reportAdapter;
DataSet reportDataSet;
ReportClass currentReport = null;
reportAdapter = new OdbcDataAdapter("call CurrentInventory()", DBConnection.getConnection());
reportDataSet = new reportDS();
reportAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
reportAdapter.Fill(reportDataSet, "CurrentInventory");
if (reportDataSet.Tables["CurrentInventory"].Rows.Count > 0)
{
currentReport = new RptCurrentInventory();
currentReport.SetDataSource(reportDataSet);
}
return(currentReport);
}