Eclipse Community Forums: BIRT » birt 2.1.1 runtime sql column alias problem

Home » Archived » BIRT » birt 2.1.1 runtime sql column alias problem

birt 2.1.1 runtime sql column alias problem [message #212842]

Fri, 19 January 2007 11:37

Eclipse User

Hello
I've created a report in All-in-One Designer 2.1.1, the sql in data set is:

select *,
CONCAT(profill_order.DELIVERY_PLACE_NAME,
profill_order.DELIVERY_PLACE_CITY,
profill_order.DELIVERY_PLACE_ZIP_CODE,
profill_order.DELIVERY_PLACE_STREET,
profill_order.DELIVERY_PLACE_PHONE,
profill_order.DELIVERY_PLACE_PERSON) as DELIVERY_PLACE
from profill_order

then i use DELIVERY_PLACE as group expresion
and in designer preview all work fine.

But when i run the report in runtime on jboss or tomcat a get an error:
There are errors evaluating script "row["DELIVERY_PLACE"]

Whats wrong?

Patryk

Re: birt 2.1.1 runtime sql column alias problem [message #213142 is a reply to message #212842]

Mon, 22 January 2007 14:58

Eclipse User

One difference is that designer only returns a subset of the data. This is
configurable in the designer preferences.
You may have null entry in one of your fields. I am not certain what CONCAT
will do with a null though.

Jason

"Patryk W

Previous Topic:	Including JavaScript in SVG Chart
Next Topic:	Web Viewer runtime error in 2.1.1 and 2.2M2

Goto Forum:

-=] Back to Top [=-

Current Time: Mon May 05 21:14:08 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter