Need to print our text messages - when no data

[jys]

Need to print our own text messages like "No records"- when no data existing after executing query

 

Presently we using,

 

WhenNoDate -(Blank page/No pages/AllSectionsNoDetail)

[Prodhuturi]

I am trying the same. Haven't found a way to do it yet. Would appreciate if someone has an answer.

[Prodhuturi]

I am trying the same. Haven't found a way to do it yet. Would appreciate if someone has an answer.

[dan_thorman]

as a part of the query, you could use a decode statement (if it's an sql query)...

 

for example, if you are pulling prices, and certain items have no price, you could make your select something like:

 

decode(price, NULL, "No Record", price)

according to the syntax:

decode (expression, search_1, result_1, default)

[Case1182]

Put a text field in the page-footer band that says NO DATA FOUND, the text fields print when = new java.lang.Boolean($V{REPORT_COUNT}.intValue() == 0 ) make sure on the report properties "When no DATA" = All sections, no detail. and try it, works great