Ireport does not recognize with statement in sql

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
luishorcajadas_1's picture
Joined: Jan 20 2017 - 11:35am
Last seen: 1 year 4 weeks ago

1 Answer:

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

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago