I have used Jaspersoft Studio to create a HTML5 Chart. In my database i have a date field. How do you set a filter control so that when someone runs a report they can select a date range so select data? Same process as when you have originally created a report in Ad-hoc and added between filter that you can then select. As I created this report directly in Studio I do not know how to do this. Any help greatly appreciated.
0 Answers:
No answers yet
Hi,
if I've got your requirements correctly, you should add 2 parameters to the report to filter data as described in the article below:
https://community.jaspersoft.com/wiki/using-report-parameters-jaspersoft...
Then, when you publish the report to a JasperReports Server, input controls will be automatically generated to filter the report data
Thank you very much this worked. Although I had to change class to java.sql.Timestamp
Much appreciated.
Only problem i have now is that i have calculated fields done in the server but they do not show up in Studio.