未知的列名称问题 [英] Unknown column name issue
问题描述
我正在使用iReport使用某些数据库连接创建JasperReports的报告。我在报告中添加了一个新字段。该字段在数据库列中不存在。我已将该列放在报表中，并使用表达式将值分配给此字段。
I'm creating a JasperReports's report using some database connection using iReport. I have added a new field to the report. That field does not exist in the database column. I have put that column in the report and assigning the value to this field using the expression.
编译正常但是当我使用数据库填写报表时，它给了我错误：
It compiles fine but when I fill the report using the database, it gives me the error:
Error filling print... Unknown column name : test
net.sf.jasperreports.engine.JRException: Unknown column name : test
at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:355)
at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:112)
at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:823)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:787)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1474)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:125)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:938)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:841)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)
at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:858)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Print not filled. Try to use an EmptyDataSource...
如何在JasperReports中使用用户定义的字段？
How can I use the user defined fields in JasperReports?
推荐答案
我不知道是什么原因导致你出现这个错误堆栈，但我认为这是因为你的SELECT中有一个字段没有匹配报表中的任何字段字段。
我的建议是在报表查询窗口中使用读取字段按钮，它使用查询字段填充字段变量，以避免以后出现问题。
I'm not sure of what causes you this error stack but I think it's because you have a field in your SELECT which does not match any field in your report Fields.
My advice is to use "Read Field" button in Report query window, it fill Fields variables with the fields of the query and avoid later problems.
这篇关于未知的列名称问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
