tony.dunlop

this seems to work NOTE both of the following require the local date class to be added to the report either add this to the <jasperReport> section at the top of source file of the report next to the <property> values : <import value="java.time.LocalDate"/>[/code]or use jasper studio and click report->properties->import->add class then type localDate, see image attached First day of last month default date java.sql.Date.valueOf(LocalDate.now().withDayOfMonth(1).minusMonths(1))[/code]Last day of last month java.sql.Date.valueOf(LocalDate.now().withDayOfMonth(1).minusDays(1))[/code]

I found it's not possibletop do directly in jasper, you can work it out in your SQL and then display in jasper though.

you might have to convert the param to a string first depending on what type your year param is. Like this : $P{year}.toString()+”-01-01”

could you not use: EDATE(TODAY(), -1000) for the parameter

You can use: EDATE(TODAY(), -1)[/code]In the parameter default field

if you're using a reverse proxy nginx will remove any headers with underscores, you need to add underscores_in_headers on; to the server directive: http://nginx.org/en/docs/http/ngx_http_core_module.html#underscores_in_headers