How to display "No records found" message

[venkatabalaji]

How to display "No records found" message using iReport when the records are not found in the database.

[Pedja]

In Edit -> Report properties set "When no data" to "No-data section", and put your static text in noData band.

[venkatabalaji]

I already tried it,but I didn't get message when no records are found in databse.please help me out.

[Pedja]

That should work 100%. Can you attach your .jrxml?

[drallpradeep]

Hi, I am using iReport 1.2.2 and unable to set the "No Record Found".

I also gone through your advise but where is the "No-data section". Can you explain it.

 

Regards,

Pradeep

drallpradeep@gmail.com

[venz_98]

i think this feature is only available on higher version I'm using 1.2.5 and i cannot see that function also try switching to higher version, i don't know if in what version this is introduced.

[Pedja]

I don't know in which version this option is introduced, but in 2.0.1 the option is located in Edit -> Report properties -> tab "More...." -> and for option "When no data" select "No-data section". And the "No records found" text should go to noData band (View -> Bands -> set the noData band height, it is 0 by default).

[kchaudhry]

For older versions here is what you can do.

 

1. Create a static text field

2. Right click on this field then go to Properties -> Common -> Print when expression and type the following

Code:

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

3. Now go to the Static Text tab and type something like

Code:

[code]Your selection has returned no results.

 

I normally place this in my Summary band.

This message will be displayed if there are no records.

Hope this helps!

[venkat562]

Hi ,

 

Is there any way to display "No Records Found in table"  String when I use Table inside Report...

 

I used Table inside report, It has separate TabeDataSet Data set. And Main Report has another Data set.

When i run report, i get data from Query used in Main DataSet, if i dont get Data from Query used in TabeDataSet,i have to dislay  "No Records Found in table" instead of blank or line for that perticular table.

Problem i faced is like this...

I cannot to access any Parameter/Field/Variable defined in TableDataSet to Main Report, So i cannot display any static text with  "Print When Expression".

Any solution/suggestion is appriciated...

Thank you...