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.