How to use Multiple Select for Add DataSet (subdataset) query in ireport/jasperserver

0

I am using ireport 560, and JS7, my query in ireport query using $X{IN, column, main_para} and in JS multiple select query check box -input control also using main_para as parameter name this way my JS multiple select triggered irep and it works fine.

in ireport i have 1 additional dataset (subdataset) with $X{IN, column, additional_para} this additional_para is link in dataset run with main_para->$additional_para,this way my JS multiple select triggered irep and raise 'there was and error on server, try again or contact admin:

error UID:0bd7efba-4a86-4652-9697-89b56bb2e208)

i change above irep para mapping by using multiple select query check box -input control also using additional_para to direct call dataset query but again raise same above error.

  -main query-
   select
    column,
    col2,
    col3
from
    main_table
where
    $X{IN,
    column,
    main_para}

column and main _para is of integer type

-add dataset query-
select
    column,
    col2,
    col3
from
    additional_table
where
    $X{IN,
    column,
    additional_para}

column and additional_para is of integer type

please assist, how to solve this.

aqadirhasan's picture
Joined: Jun 19 2014 - 2:32am
Last seen: 18 hours 16 min ago

0 Answers:

No answers yet
Feedback
randomness