irnewbie Posted February 4, 2011 Share Posted February 4, 2011 HiI have a report that showed 1 record and since changing the query it now does not return any records as Iwas wanting to happen but even though running the report query in the DB shows no records I keep getting this one record showing in the report previewer. I have tried closing down iReports, deleting the .jasper and recompiling, even creating a new test report and it does not help. How can the same query in the same database as the report is getting the data from return a record in the report but not in the DB?Thanks for any helpful suggestions.IRNewbie Link to comment Share on other sites More sharing options...
irnewbie Posted February 5, 2011 Author Share Posted February 5, 2011 HiIs there anyone who knows what might be causing this, I am stumped. If i pull the exact query from the report and run it in the DB it shows no records, as I want, but in the report viewer it shows the one record that was showing before I had altered the query. I have check the xml and the query is exactly the same one that returns no records in the DB.ThanksIRnewbie Link to comment Share on other sites More sharing options...
irnewbie Posted February 5, 2011 Author Share Posted February 5, 2011 I now have yet another report doing something similar, I have set up the data in the DB to show one record, and the query does just that, but in the report it is showing no data, yet this is exactly the same query. Is this a bug or something in iReport. I mean it is the exact same query on the DB and in the report yet opposite results returned. Link to comment Share on other sites More sharing options...
irnewbie Posted February 5, 2011 Author Share Posted February 5, 2011 I closed sql developer and found there to be uncommited changes so this must have been the problem. I always commit at the end of any DML but must have missed one, the report now works. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now