Issue
I have a BIRT report which worked fine up until I altered the database it connected to. I deleted a column out of a table on the database and removed any call to it in my data query and now I'm getting this error whenever I try and generate a BIRT report.
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)
A google search isn't turning up much other then unresolved issues, and I'm not sure how to proceed. I've tested out the query in phpmyadmin, and it returns the expected results, yet in BIRT I get nothing. Any ideas?
Solution
Most likely you have a reference of the deleted column in the report XML file, go to the XML view and search for : "isComplete_18", "name_19", and delete each xml element containing that string.
After manually removing every reference to the two columns, rerun the report again ...
Answered By - aleroot
