Skip to Content
0
Former Member
Jun 09, 2016 at 09:11 AM

Error code while trying to insert subreport via command

17 Views

Hi everybody,

if I try to apply the following sql-statement in a subreport out of jasper (ireport):

SELECT

jptsys_web_cust_prop.jptsys_web_cust_prop_id field_id,

jptsys_web_cust_prop.jptsys_web_cust_prop_n field_n,

jptsys_web_cust_prop.jptsys_web_cust_prop_sc field_sc,

jptsys_web_cust_prop.property_type field_type,

jptsys_web_cust_prop_cont_id cont_id,

COALESCE(

TO_NCLOB(jptsys_web_cust_prop_cont.string_val),

TO_NCLOB(jptsys_web_cust_prop_cont.string_value),

TO_NCLOB(jptsys_web_cust_prop_cont.integer_val),

TO_NCLOB(jptsys_web_cust_prop_cont.decimal_val),

TO_NCLOB(TO_NCHAR(jptsys_web_cust_prop_cont.date_val, 'DD.MM.YYYY')),

(SELECT

TO_NCLOB(MAX(jptsys_web_lkup_data.jptsys_web_lkup_data_n))

FROM

jptsys_web_lkup_data

WHERE

jptsys_web_lkup_data.jptsys_web_lkup_data_id = jptsys_web_cust_prop_cont.single_sel_val_id

)

) field_value,

jptsys_web_cust_prop_cont.descrip_grp_id field_descrip_id

FROM

jptsys_web_cust_prop,

jptsys_web_cust_prop_cont

WHERE

jptsys_web_cust_prop_cont.jptsys_web_cust_prop_id = jptsys_web_cust_prop.jptsys_web_cust_prop_id AND

jptsys_web_cust_prop_cont.entity_id = $P{EVENT_ID} AND

jptsys_web_cust_prop.jptsys_web_cust_prop_id = '2316'

ORDER BY jptsys_web_cust_prop_cont.jptsys_web_cust_prop_cont_id

I get this error message:

Anybody who can help?

Rgds

Eberhard

Attachments