Hello,
i want to use dynamic dates (http://community.jaspersoft.com/wiki/dynamic-dates-reports) to create a input control list with "Yesterday, Last Month,etc"
I build the class and in iReprt it works great. (import the jar file). Then i deploy the report on the jasperserver and also uploaded the jar file. but now there are no visible input controls.
please can you help me?
3 Answers:
Create an "input control" with type "single select query".
Enter a SQL query to select the date values you want, like "to day", "yesterday" and "last month" like:
select current_date() as id, 'Today' as name
union
select date_sub(current_date(), interval 1 day) as id, 'Yesterday' as name
union
select date_sub(current_date(), interval 1 month) as id, 'Last month' as name
You can add as much "union select..." as you want
When you deploy the report to the server, you also need to create input controls....did you do this? In iReport the parameters are prompted for, but in the server you must create an input control with the same name as the Parameter to get it to show up. If you right click on the reports in the repository and click edit, you will see under Controls and Resources if there are any input controls defined.
