2001 JI Open Discussion Posted August 14, 2006 Share Posted August 14, 2006 By: Eric Mendes - ointocavel Select returns 0 rows 2002-06-01 06:58Hi all, I have a jsp aplication. My problem is when my select returns 0 rows. I want to know how to treat this thing, because, when the report shows no data the scream turns empty and no messages appear. I don t know how to do to make the program show a message informing that there is no data (0 rows). thanks in advance Eric By: Teodor Danciu - teodord RE: Select returns 0 rows 2002-06-03 02:21 Hi, When the data source of the report contains no records, the resulting document has no pages either. There are to approaches to this problem: Either you perform a test before launching the report generation to see how many records will be retrieved (using SELECT COUNT(*) statement for example). Or you could test the resulting JasperPrint object before passing to other output formats, to see if it contains at least one page. I hope this helps. Teodor 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