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

Help

Home

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

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

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

Fri, 19 January 2007 16:37

Patryk Wasik

Messages: 1
Registered: July 2009

Junior Member

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

Report message to a moderator

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

Mon, 22 January 2007 19:58

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

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

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 04 21:20:50 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter