Ireport does not recognize with statement in sql
Posted on January 20, 2017 at 11:49am
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
Posted on January 22, 2017 at 1:21pm
Try using Jaspersoft Studio instead. iReport has some limitations and bugs and development has already terminated. The current JasperReports designer tool is Jaspersoft Studio.