Jump to content
Changes to the Jaspersoft community edition download ×

No data message


2006 IR Open Dicussion

Recommended Posts

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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...