SQL 'IN' Syntax only returning first in the list

[nealhudson]

Hi there

 

I'm trying to pass in a range of values into a report, and using this parameter in the WHERE clause of my SQL statement using the 'IN' operator, e.g.

SELECT * FROM table WHERE value IN ($P{in_param})

 

When I run this in my query browser for a range of values it works fine. When I run this the same thing in iReports it only retrieves records for the first value in the list.

 

Any idea what the problem is?

 

Also - how can I view the actual SQL that iReports runs?