Probably a very simple question

[ScottH]

Hi guys,

 

Been using iReports for about 6 months; great product!

 

Something we're trying this week and having great deal of trouble is this passing in a String Parameter so as to execute a query like this:

 

select product_name, product_desc, vendor_name from products where vendor_name in ( '$P{vendors}' )

 

* the vendor_name column is a varchar column in the database.

* the vendors parameter will come in looking like this: SOME VENDOR NAME1, SOME VENDOR NAME2, etc, etc.

 

When you paste the SQL into a query tool and fill it in, it works great, but I get "report contains no data" when I run it.

 

[1] is this the way you would approach this?

[2] is there a way to get the SQL that is fed is generated from the compiled report?

 

Thanks for reading this!

 

Scott

Code:

Post edited by: ScottH, at: 2006/08/02 20:58