Hello, I would like to schedule a report with default selections in a parameter. The parameter needs to be dynamic, like a select list that generated from a SQL Query.
This way, items selections in the parameter are dynamic with what is available in the database and we can change our selections if we want before re-scheduling the report.
Do I need to do this with an input control, parameter or both?
Parameters are defined in Jaspersoft Studio to obtain values during runtime to use in a report. Input Control are just user entry component that passed user's input to a parameter.
Hello Hozawa, thanks. How would I then create a parameter that uses a query to obtain its select list values ?
Before you question further, recommend that you read Jaspersoft Studio User Guide on what parameters are:
Read about P! parameters
And JasperReports Server User Guide on Input Controls: