title: Get List of Values (LOV) from sql query in JasperReport
body: <p>In Oracle Reports I am able to run reports which get parameters by querying from database. In PHP/mySQL I am able to populate data in HTML dropdown menu by using sql query.</p>
  
  <p>I would like to do the same in my JasperReports, either using JasperReport Studio or using JasperReport Server input controls. The current LOV I am able to get using JReport 'Input Controls' makes me enter options manually.</p>
  
  <p>This is what I am trying to explain in words: </p>
  
  <p><img src="https://i.stack.imgur.com/OHXVG.png" alt="Get Jasper report to show LOV/dropdown menu to display data from my database table"></p>