How to display "No records found" message

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

[mfirkser]

Have you tried adding a No Data Section - which includes a message saying "No records found"?

Code:

<noData>  <band height="276">    <textField>      <reportElement positionType="Float" x="0" y="40" width="842" height="20"/>	<textElement textAlignment="Center">	  <font size="12" isBold="true"/>	</textElement>	<textFieldExpression><![CDATA["NO DATA RETURNED"]]></textFieldExpression>    </textField>  </band></noData>

[venkat562]

Thanks for your reply.

 

Actually this part of code snippet is applicable for entire report when no records found in Main Report Query.

 

But i'm using Tables inside Report. These tables will have separate Data sets...

ex:

In a report i have N no of tables, I have data in 1 table i will display that table,

When i don't have data in second table then i have to display Message saying 'No records found in this table'. Now it is displaying single line when there is no data in that table.