|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
再做一个主从报表,报表中数据源Rs1是主表,ds1是从表,相同字段是CBFBM,ACTION主表对应:
public static Table querycbf(){
String mssql = "SELECT CBFBM,CBFMC,CBFZJHM FROM CBF WHERE CBFBM = '210781101200010077'";
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(DatabaseProduct.MSSQL.name(),mssql);
return SQL.select(sqlMap,null,"/LandManagerSys/LandInfoMgr/data");
}
从表对应:
public static Table queryjtcy(){
//String mssql = "SELECT CYXM, YH.MC AS YHZGX, XB.MC AS CYXB, ZJLX.MC AS CYZJLX, CYZJHM, CYBZD.MC AS CYBZ FROM CBF_JTCY CBF_JTCY LEFT JOIN ";
String mssql = "SELECT CBFBM,CYXM,YHZGX,CYXB,CYZJLX,CYZJHM,CYBZ FROM CBF_JTCY WHERE CBFBM = '210781101200010077'";
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(DatabaseProduct.MSSQL.name(),mssql);
return SQL.select(sqlMap,null,"/LandManagerSys/LandInfoMgr/data");
}
运行报错:
Caused by: java.lang.RuntimeException: 选择节点失败,xpath:dataset('Rs1_master')/CBFBM/record
at com.justep.report.TransformContext.a(Unknown Source)
at com.justep.report.CompiledTable.selectXPathNodes(Unknown Source)
at com.justep.report.Repeat.compile(Unknown Source)
at com.justep.report.TableRows.compile(Unknown Source)
at com.justep.report.Table.transform(Unknown Source)
at com.justep.report.Content.transform(Unknown Source)
at com.justep.report.ContentSet.transform(Unknown Source)
at com.justep.report.Report.a(Unknown Source)
at com.justep.report.ReportDocument.transform(Unknown Source)
at com.justep.report.ReportTransformer.transform(Unknown Source)
at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
... 22 more
Caused by: java.lang.NullPointerException
at net.sf.saxon.dom4j.NodeWrapper.makeWrapper(NodeWrapper.java:99)
at net.sf.saxon.dom4j.NodeWrapper.makeWrapper(NodeWrapper.java:62)
at net.sf.saxon.dom4j.DocumentWrapper.wrap(DocumentWrapper.java:55)
at com.justep.report.TransformContext.a(Unknown Source)
... 33 more
请大神 给看看是怎么回事啊?
|
|