Parameter or Input Control

[frank.py]

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?

Thanks,

Frank

[hozawa]

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.

[frank.py]

Hello Hozawa, thanks. How would I then create a parameter that uses a query to obtain its select list values ?

thanks,

Frank

[hozawa]

Before you question further, recommend that you read Jaspersoft Studio User Guide on what parameters are:

http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v621/using-parameters

Read about P! parameters

http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v621/using-parameters-queries#jss-user-parameters_221620694_1025261

 

And JasperReports Server User Guide on Input Controls:

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v621/running-report-input-controls-or-filters