Ireport does not recognize with statement in sql

[luishorcajadas_1]

 

Ireport does not recognize with statement, and gives error when executing against Oracle DB: WITH location as (select name from table1) Select name from location This code executes it in sqldeveloper and it works

[hozawa]

Try using Jaspersoft Studio instead. iReport has some limitations and bugs and development has already terminated. The current JasperReports designer tool is Jaspersoft Studio.