Jump to content
Changes to the Jaspersoft community edition download ×

Probably a very simple question


ScottH

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!

 

Scott

Code:

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...