wpfeiffe

Matt, Thanks for you response. I tried just putting in the comma delimited strings and it certainly works and this is good. However, I immediately must ask how iReport handles String values with commas? I really expected to see the individual strings delimited by at least some type of quotes. Perhaps the proper question is: can you point me to the docs that specify how this works. I have the paid documentation, but didn't see anything concerning how this (Entering collection parameters in iReport gui) works. Given that it works at all, I would leave good enough alone, but I am trying to sell this to my dba/report writers group who will ask me the same questions I'm posting here. Thanks for any additional help and especially for your first answer which got this working for me! Bill

I have a very simple report that uses the $X{} syntax to build the IN clause. I have test code written in groovy that runs the report just fine by passing in a collection of Strings. My question is, how do I provide the same input when previewing the report within iReport? I have the parameter of type java.util.Collection and get prompted for it when I attempt to preview, at which point I get a single line edit control. Doing research on this forum, I have seen the following syntax suggested: Code:java.util.Arrays.asList(new String[]{"String1", "String2"})I tried this with the same dataset as I use in my test code (which produces rows just fine), but all I got was an empty report.