Hi, i use $X{IN, <column_name>, <parameter_name>}$X{IN, <column_name>, <parameter_name>} in my querys. But its very slow (3-5 Minutes to generate a report). when i changed it to: where id in ($P!{list})[/code]and use a parameter: $P!{list} = org.springframework.util.StringUtils.collectionToCommaDelimitedString($P{list_ids}) its much faster (10 seconds) Did you know why? Thx!