急求解决birt 配置maximo系统报表的问题

574126

The following items have errors:

ReportDesign (id = 1):
+ There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
maximoDataSet.open();

current_dt = 0;
startdt_jdbc = MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]);
startdt = MXReportSqlFormat.getStartDayTimestamp(params["startdate"]);
enddt_jdbc = MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]);
enddt = MXReportSqlFormat.getEndDayTimestamp(params["enddate"]);

var sqlText = new String();

sqlText = "select asset.assetnum, asset.description, asset.siteid, sum(workperiod.workhours) sched_hrs"
+ " from asset left outer join workperiod on asset.orgid = workperiod.orgid"
+ " and asset.calnum = workperiod.calnum and workperiod.workdate between " + startdt_jdbc + " and " + enddt_jdbc
+ " where (asset.shiftnum = workperiod.shiftnum or asset.shiftnum is null) and " + params["where"]
+ " group by asset.assetnum, asset.description, asset.siteid";

maximoDataSet.setQuery(sqlText);":
{1}.

plj1234520

同求。。。请问楼主解决了吗