Column binding has referred to a data set column which does not exist

Hello, 
 
I created over 70 reports using eclipse Galileo, BIRT version 2.5.2, SQL Server 2008, and jtds driver version 1.2.5 
 
I have 2 reports that generates this message 
 
Column binding "GROUPOFID" has referred to a data set column "GROUPOFID" which does not exist 
 
The same query is referenced in other reports without issues. 
 
The query is below: 
 
SELECT ENSGROUPS.GROUPOFID, 
ENSGROUPS.GROUPTYPE, 
ENSGROUPS.GROUPEXCLSEL, 
ENSGROUPS.GROUPNAME, 
ENSGROUPS.PARENTGROUPOFID, 
ENSACTIONS.STATUSCODE, 
ENSTRIGGERS.TRIGGERNAME, 
ENSACTIONS.ACTIONNAME, 
ENSACTIONS.ACTIONID, 
ENSACTIONS.ACTIONINCID, 
ENSSELECTED.SELECTID 
FROM (ENSGROUPS LEFT OUTER JOIN ENSACTIONS ON ENSGROUPS.GROUPOFID = ENSACTIONS.GROUPOFID 
LEFT OUTER JOIN ENSTRIGGERS ON ENSACTIONS.STATUSCODE = ENSTRIGGERS.TRIGGERCODE 
LEFT OUTER JOIN ENSSELECTED ON ENSGROUPS.GROUPOFID = ENSSELECTED.GROUPOFID) 
WHERE ENSSELECTED.SELECTID = ? 
AND ENSSELECTED.SELECTSTRING = ? 
AND ENSGROUPS.GROUPTYPE = ? 
AND ENSACTIONS.STATUSCODE LIKE ? 
AND ENSGROUPS.GROUPEXCLSEL <> 1 
ORDER BY ENSGROUPS.GROUPNAME 
 
The dataset is assigned to a BIRT Table object embedded within a BIRT List object 
Parameters are defined in the table object>Binding>Data Set Parameter Binding (using Available Column Bindings within List object) 
 
I have tried Table refresh (earlier posts) without success.

Find more posts tagged with

Comments

Virgil Dodson

Moving to the Designing BIRT Reports forum to see if others there have seen this message.

joeguzman1

03.09.2011 This issue went away in BIRT 2.6.1 
 
The reports seem to run fine in BIRT 2.6.1 runtime. 
 
Please leave a post if I missed something. 
 
Thank you for your time.

arunkumarb

Double click on dataset which you are using. Now click on output columns and paste GROUPOFID in Alias and Display Name columns. May be it works.

Regards,
Arun