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.
