java - BIRT report error column binding -
i have birt report worked fine until altered database connected to. deleted column out of table on database , removed call in data query , i'm getting error whenever try , generate birt report.
the following items have errors: data (id = 291): + column binding "iscomplete_18" has referred data set column "iscomplete_18" not exist. (element id:291) data (id = 298): + column binding "iscomplete_18" has referred data set column "iscomplete_18" not exist. (element id:298) data (id = 292): + column binding "iscomplete_18" has referred data set column "iscomplete_18" not exist. (element id:292) data (id = 299): + column binding "iscomplete_18" has referred data set column "iscomplete_18" not exist. (element id:299) data (id = 293): + column binding "iscomplete_18" has referred data set column "iscomplete_18" not exist. (element id:293) data (id = 300): + column binding "iscomplete_18" has referred data set column "iscomplete_18" not exist. (element id:300) data (id = 585): + column binding "iscomplete_18" has referred data set column "iscomplete_18" not exist. (element id:585) table (id = 443): + column binding "name_19" has referred data set column "name_19" not exist. (element id:443) data (id = 583): + column binding "iscomplete_18" has referred data set column "iscomplete_18" not exist. (element id:583)
a google search isn't turning other unresolved issues, , i'm not sure how proceed. i've tested out query in phpmyadmin, , returns expected results, yet in birt nothing. ideas?
most have reference of deleted column in report xml file, go xml view , search : "iscomplete_18", "name_19", , delete each xml element containing string.
after manually removing every reference 2 columns, rerun report again ...
Comments
Post a Comment