No data message

[2006 IR Open Dicussion]

By: Javy Dreamer - javydreamercsw

No data message

2006-05-31 12:51

Is there a way to display a meesage if no data is returned? Like adding a text field that is visible only when no data is present (opposite to remove line if blank). It's just to display a message like analysis done but no data related found.

 

Any help/idea is welcomed.

 

Thanks!

 

 

 

 

 

By: ryan - ryankee

RE: No data message

2006-06-05 05:20

First, create a static text such as "No Record Found". Next double click the static text and in the Print When Expression, enter

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

& $V{PAGE_NUMBER}.intValue()== 1 )"

Lastly, in the report properties, select "Floating column footer" and select "AllSectionsNoDetail" for When no data

 

Hope this helps!

Ryan

 

 

 

 

By: Javy Dreamer - javydreamercsw

RE: No data message

2006-06-05 14:19

I assume that this field is to be placed in the sub report. I've tried many ways but it just doesn't work. It only shows an empty page (if in the subreport) or as an empty space (in the main report).

 

 

Thanks for the help.

 

 

 

 

By: ryan - ryankee

RE: No data message

2006-06-06 02:59

This static field does not have to be placed in the subreport. You should place it in the main report in the column footer band. The Print When Expression will take care of displaying this message when your main report query does not return any record.

 

 

 

 

By: Javy Dreamer - javydreamercsw

RE: No data message

2006-06-06 11:29

Thanks! It did work!