Jump to content
We've recently updated our Privacy Statement, available here ×

input control from SQL query - newbie


Mary.Tyckoson

Recommended Posts

I'm trying to create a simple input control of multiple text values, e.g. itype IN ('fbk','fsr','fvi'), selected from a query of the database (sybase ASE 15.5).  I'm using the lastest versions of JasperServer Community ed. and Jasper Studio.  I'm completely stumped on creating the input control.  I know that, in addition to the setup of query and input control on the server side, I need a parameter that defines and calls the query (select itype from itype) on the jrxml side, and I've gotten this far, but everything I've tried from here fails.  Can anyone show me an example of what the source code should look like, or any other help? Getting desperate.  Screenshots of parameter and source attached.

converted-file.png.462cd90c0337213286ed7af899223c44.png

the source code looks like below

converted-file.png.1c15787010925a06bde7d67ad6735624.png

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

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