Column alias/name ignored [message #1386327] |
Mon, 16 June 2014 15:24 |
Burgess Howard Messages: 1 Registered: June 2014 |
Junior Member |
|
|
We are running BIRT from command line and are in the process of trying to upgrade from 2.5.1 to 4.3.2, but we have run into an issue when trying to run our existing reports.
When running one of our existing reports with 4.3.2 we get an exception complaining about a column (ex. Total_4) that doesn't exist that is referenced in one of our charts. The column reference in this case is an alias for one of our columns setup in the queryText attribute of our data source.
Example:
<xml-property name="queryText"><![CDATA[SELECT "Name_1","Action_2","COUNT3_3","SUM4_4" FROM result-2 : {"Event Subtype_1","Name_1",STRING;"Event Subtype_2","Action_2",INT;"Count_3","COUNT3_3",BIGDECIMAL;"Total_4","SUM4_4",BIGDECIMAL}]]></xml-property>
I tested the same report with 4.2.2 and it worked fine. I also have opened the rptdesign file in eclipse with both 4.2.2 and 4.3.2. Eclipse with 4.2.2 shows the correct alias whereas Eclipse with 4.3.2 does not show the aliases at all.
Has something changed between 4.2.2 and 4.3.2 or is this a bug in 4.3.2?
|
|
|
|
Powered by
FUDForum. Page generated in 0.03077 seconds