SQL Results shows fine but different results shown in .JASPER file


Hi All,

I am currenlty working with .JRXML files and .JASPER report on my spring application. 

The SQL query that i am running is:

SELECT * FROM account WHERE ind = 'Y'

The database shows the correct results. However, in the JASPER report it's showing the following results:

SELECT * FROM account

Is there a reason why the SQL query result doesn't work in the JASPER report? Or is there some sort of cache when the .JASPER file is compiled? Or can that be related to a library issue?

Thanks in advance!

JasonJ's picture
Joined: Jul 2 2020 - 8:22pm
Last seen: 7 months 2 weeks ago

0 Answers:

No answers yet