Jump to content
Changes to the Jaspersoft community edition download ×

Probably a very simple question


Recommended Posts

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!




Post edited by: ScottH, at: 2006/08/02 20:58
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...