|
版本: |
X5.2.7 |
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
本帖最后由 nanfeng 于 2019-11-19 09:22 编辑
报表的数据源是自己写的action,代码如下:后台调试已经查出数据
public static Table queryStatistics(String startDate,String endDate){
String whereCondition="where (ZGS_DATABASE.ZG_PU_ORDER.FAPPLYDEPTNAME = ZGS_DATABASE.ZG_PU_DEPT.FDEPT) and ZGS_DATABASE.ZG_PU_ORDER.FAPPLYTIME between to_date('"+startDate+"','yyyy-mm-dd') and to_date('"+endDate+"','yyyy-mm-dd')";
String sql = "select ZGS_DATABASE.ZG_PU_DEPT.FDEPT," +
"(select sum(fOriPrice) from ZGS_DATABASE.ZG_PU_ORDER "+whereCondition+") as oriMoney, " +
"(select sum(fOrderTaxPrice) from ZGS_DATABASE.ZG_PU_ORDER "+whereCondition+") as taxMoney, " +
"(select sum(FAMOUNT) from ZGS_DATABASE.ZG_PU_ORDER "+whereCondition+") as money " +
"from ZGS_DATABASE.ZG_PU_DEPT,ZGS_DATABASE.ZG_PU_ORDER group by ZGS_DATABASE.ZG_PU_DEPT.FDEPT ";
HashMap<String, String> sqlDetail = new HashMap<String, String>();
sqlDetail.put(DatabaseProduct.DEFAULT.name(), sql);
Table t = SQL.select(sqlDetail, null, "/zgs_oa/purchase/data");
return t;
}
这是给action传的参数:开始和结束时间;
var reportDate = justep.xbl('reportData1');
reportDate.setStringVar("startDate", startDate);
reportDate.setStringVar("endDate", endDate);
justep.xbl('report1').refresh();
这是页面的配置信息:
在页面上报表数据不展示,如下图,也没报错:请问这是什么原因?
|
|