I am using JasperServer 5.6.0 and iReport. I am trying to create a cascading input control where the first input control (organization) is multi-select. That input control seems to work properly. The problem comes in when I try to create the 2nd level input control (unit).
1st Level parameter = organization (mult-select input control)
2nd Level parameter (cascading from organization) = unit (multi-select input control)
This is the basic syntax I'm using for the query to populate the 2nd level (unit) input control.
select distinct UnitId, Name from Unit
When I execute the report on the server, I get no input controls. When I look in the jasperserver.log, it is blank. I've tried restarting my services but doesn't seem to trigger any logging. Hopefully someone can tell me what I'm doing wrong.
I've found JasperReports Server input controls is OK for very simiple querying but found it to be very limited in functionalities to be useful in actual systems.
I had a situation where users wanted to enter multiple query fields, show results from the query, and then to select checkboxes on customers whom they wanted to generate a report. They also wanted all customers report to be generated in 1 single pdf file instead of a pdf file for each customer.
What I ended up doing was create a custom jsp page to do this.