How to join an empty dataset without error?

I'm combining two webservice datasets with an left join. So far so good...as long as the right dataset is not empty otherwise the BIRT runtime engine (I'm using the webviewer) emits an error telling me the right join column fails to be evaluated. Anybody knows how to workaround this bug?

BIRT version: 2.3.2-RC2
Error:
Table (id = 1581):
+ Fail to compute value from sort, group or filter expression.
A BIRT exception occurred: There are errors evaluating script "dataSetRow["stationId"]":
Invalid field name: stationId. (<inline>#1).. See next exception for more information.
There are errors evaluating script "dataSetRow["stationId"]":
Invalid field name: stationId. (<inline>#1).

Find more posts tagged with

Comments

mwilliams

Hi btyla,

Does this only happen with web services dataSets or anytime one is empty for any type?

btyla

The project requires reporting based on webservices so I haven't tried any other data source yet.<br />
<br />
BTW I logged this problem in the BIRT bug tracker as <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=265965'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=265965</a>

mattias

I experienced the same problem with a data set connected to a JDBC data source.

Anyway, the bug seems to be fixed in 2.5, downloaded the nightly build and verified it with my report design. My workaround in the mean time is to switch the two data sets (and from left to right join). My other data set is connected to a scripted data source and is never empty.