In a report I'm using a SQL query to retrieve the necessary data. Using the identical query in both tools I'm getting different results in SQL developer and Jaspersoft. Can someone point me in a possible direction of what is going on? I have to mention that the query performed is large (execution time 40 seconds +); maybe of relevance.
So my main question is what can be causing the differences in results?
ps. I checked the different db settings.... they are all the same.