java - BIRT 报告错误列绑定(bind)

Question

我有一份 BIRT 报告，在我更改它所连接的数据库之前它一直运行良好。我从数据库表中删除了一列，并在我的数据查询中删除了对它的任何调用，现在每当我尝试生成 BIRT 报告时都会收到此错误。

The following items have errors: 

Data (id = 291): 
+ Column binding "isComplete_18" has referred to a data set column "isComplete_18" which does not exist. (Element ID:291) 

Data (id = 298): 
+ Column binding "isComplete_18" has referred to a data set column "isComplete_18" which does not exist. (Element ID:298) 

Data (id = 292): 
+ Column binding "isComplete_18" has referred to a data set column "isComplete_18" which does not exist. (Element ID:292) 

Data (id = 299): 
+ Column binding "isComplete_18" has referred to a data set column "isComplete_18" which does not exist. (Element ID:299) 

Data (id = 293): 
+ Column binding "isComplete_18" has referred to a data set column "isComplete_18" which does not exist. (Element ID:293) 

Data (id = 300): 
+ Column binding "isComplete_18" has referred to a data set column "isComplete_18" which does not exist. (Element ID:300) 

Data (id = 585): 
+ Column binding "isComplete_18" has referred to a data set column "isComplete_18" which does not exist. (Element ID:585) 

Table (id = 443): 
+ Column binding "name_19" has referred to a data set column "name_19" which does not exist. (Element ID:443) 

Data (id = 583): 
+ Column binding "isComplete_18" has referred to a data set column "isComplete_18" which does not exist. (Element ID:583) 

谷歌搜索并没有出现其他 Unresolved 问题，我不确定如何继续。我已经在 phpmyadmin 中测试了查询，它返回了预期的结果，但在 BIRT 中我什么也没得到。有什么想法吗？

Answer 1

您很可能在报告 XML 文件中引用了已删除的列，转到 XML View 并搜索:“isComplete_18”、“name_19”，然后删除包含该字符串的每个 xml 元素。

手动删除对两列的所有引用后，再次重新运行报告...