2006 IR Open Dicussion Posted September 5, 2006 Share Posted September 5, 2006 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! 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