Parameter or Input Control

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

frank.py's picture
Joined: May 25 2016 - 12:32pm
Last seen: 6 years 6 months ago

3 Answers:

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.

hozawa's picture
177867
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 12 months ago

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

thanks,

Frank

frank.py's picture
Joined: May 25 2016 - 12:32pm
Last seen: 6 years 6 months ago

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

http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-us...

Read about P! parameters

http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-us...

 

And JasperReports Server User Guide on Input Controls:

http://community.jaspersoft.com/documentation/tibco-jasperreports-server...

hozawa's picture
177867
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 12 months ago
Feedback