Display a message when no rows found.

[2005 IR Help]

By: SSG - shivasg

Display a message when no rows found.

2005-05-04 10:30

How to display a user message instead of a blank page when no rows returned ?

 

 

 

 

By: alanHardwick - alan314

RE: Display a message when no rows found.

2005-05-05 23:32

You can use a similar method as described on the below Jasper Post (i.e. test for no records within java code and then display ur no records message in Swing or whatever you are using).

 

http://sourceforge.net/forum/forum.php?thread_id=1278635&forum_id=113530

 

 

 

 

By: dtecosta - dantecosta

RE: Display a message when no rows found.

2005-05-06 07:17

I do this... I read your link.. I'm using iReport, so when I put NoPages and nothing have change...

The problem is same, the query have no results and on the relatorio show the header...

how can I put it out??

 

tanks

 

 

 

 

By: eileene_c - eileene_c

RE: Display a message when no rows found.

2005-05-09 22:05

What I did with our report is this:

 

1) In Report Properties, set When no data to AllSectionNoDetail.

 

2) Use the PrintWhenExpression for each band.

For example, for the Page header, put in:

new Boolean($V{REPORT_COUNT}.intValue()>0)

or new Boolean($F{SAMPLE}!=null) where SAMPLE is a non-null field when there are rows returned.

 

3) Then place the user message in another band, let's say column footer or summary. and in its PrinWhenExpression, put in:

new Boolean($V{REPORT_COUNT}.intValue()==0)

 

 

 

 

 

 

 

 

By: dtecosta - dantecosta

RE: Display a message when no rows found.

2005-05-10 05:07

thank you!.. I've sucessful whith this expression...