Eclipse Community Forums: BIRT » Column binding "COLUMN_ALIAS" has referred to a data set column "COLUMN

Help

Home

Home » Archived » BIRT » Column binding "COLUMN_ALIAS" has referred to a data set column "COLUMN_ALIAS" w

Show: Today's Messages :: Show Polls :: Message Navigator

Column binding "COLUMN_ALIAS" has referred to a data set column "COLUMN_ALIAS" w [message #1441091]

Thu, 09 October 2014 08:48

Juraj Marusiak

Messages: 4
Registered: October 2014

Junior Member

I have upgraded BIRT on our server from 3.7.0 -> 4.4.1 version. Now, when I try run my reports, some of the reports display the error:

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

This ocures, if the column binding reference an ALIAS in my SQL dataset. If I do not use ALIASES, everything seems to be fine.

Any idea, how I can fix this problem on the server? I do not want to redesign all the reports and remove SQL ALIASES from it ..

Is there any other way?

Thank you for your help in advance,

Juraj

Report message to a moderator

Re: Column binding "COLUMN_ALIAS" has referred to a data set column "COLUMN_ALIAS&quo [message #1441514 is a reply to message #1441091]

Thu, 09 October 2014 21:10

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Is this something you can reproduce with the sample database and attach in here? That way I can see and test on the issue. Smile

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Column binding "COLUMN_ALIAS" has referred to a data set column "COLUMN_ALIAS& [message #1441863 is a reply to message #1441514]

Fri, 10 October 2014 09:35

Juraj Marusiak

Messages: 4
Registered: October 2014

Junior Member

Hello. Thanks for your effort.

I was able to reproduce the problem with the sample db. Simple query:

select
orderDate,
requiredDate,
shippedDate,
status as st
from
orders;

I want to display data in the table, but dataSetRow["st"], nor dataSetRow["status"] works. I get this exception:

org.eclipse.birt.report.engine.api.EngineException: Column binding "status" has referred to a data set column "status" which does not exist.

Am I doing something wrong?