|
20金币
我在写纯SQL报表过程中遇到一些问题
现在写出来过程,希望得到指点
注:数据源等配置无误
1.BIZ上新建一个应用。名report
2.report上右键新建一个业务模块,名base_report
3.点开base_report,找到ontology在上面右键新建ontology文件,名:report_ontology
4.在report_ontology上点反向生成本体。选择数据源选择表 ->添加概念->添加关系。映射字段 全选,标准动作设置点添加,新增queryaction 保存
5.process上新建process文件,新建report_process。report_process的动作上和mainactivity上动作 添加queryaction的动作。
进入到UI层:
1.report.function.xml上添加菜单。添加功能菜单,选择上面新建的report_process
2.report子节点的base_report->process->report_process新建W文件。向导选择报表,网格报表。
数据源类型选择action,action选择query的那个action 业务字段。写入一个选择的表的 5个字段,用逗号分割: 为 ID,FBizDate,FYearMonth,FInvCode,FInvName
在转到显示列,把字段都添加进去,确定
3.启动tomcat,进去x5。添加角色功能,注销重新登陆。
4.找到刚添加的报表,点击打开
报错
UIServer错误URI:/x5/report/report/process/report1/mainActivity.w错误码:500错误信息:java.lang.RuntimeException: Excel生成报表定义失败,文件名:E:\X5 v5.2_SP2\v5.2_SP2\x5.2\model\UI\report\report\process\report1\reports/mainActivity_gridReport.xls
隐藏错误详细java.lang.RuntimeException: Excel生成报表定义失败,文件名:E:\X5 v5.2_SP2\v5.2_SP2\x5.2\model\UI\report\report\process\report1\reports/mainActivity_gridReport.xls at com.justep.report.xls.XLSTransformer.transform(Unknown Source) at com.justep.xbl.report.Report.generateReportDoc(Report.java:351) at com.justep.xbl.report.Report.generateReportDefine(Report.java:320) at com.justep.xbl.report.Report.execute(Report.java:70) at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source) at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source) at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source) at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source) at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source) at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source) at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source) at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source) at com.justep.ui.util.UIUtils.xbl(Unknown Source) at com.justep.ui.WindowCompiler.compile(Unknown Source) at com.justep.ui.WindowServer.getWindow(Unknown Source) at com.justep.ui.WindowServer.service(Unknown Source) at com.justep.ui.servlet.MainServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:595)Caused by: java.lang.RuntimeException: Excel生成报表定义失败 at com.justep.report.xls.XLSTransformer.transform(Unknown Source) ... 30 moreCaused by: java.lang.NullPointerException at com.justep.report.xls.XLSTransUtils.initDataSource(Unknown Source) at com.justep.report.xls.XLSTransModel.a(Unknown Source) at com.justep.report.xls.XLSTransModel.transform(Unknown Source) ... 31 more
|
最佳答案
查看完整内容
刚远程看了下
主要是他的java代码路径写的有问题
报表设置都是好的
|