Jump to content
Changes to the Jaspersoft community edition download ×

Select returns 0 rows


Recommended Posts

By: Eric Mendes - ointocavel

Select returns 0 rows

2002-06-01 06:58

Hi 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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...