Hi Team, I have been trying to create a variable which will count the number of records in a database field. I do not want to display the record count but want to use it in Print When expression. To provide more details i have created a Group header and have only a text to display which is "No records found for this type". Have created a variable Count_Field (Integer) , reset type = "Report" Increment is none and in Expression : $F{FULL_NAME} which is the field i want to count. My condition is when the count of the field (FULL_NAME) Count_Field == 0 then print the band otherwise do not print. Now i am putting the condition on the Group header band Print when $V{Count_Field}== null || $V{Count_Field}==0 , but it works some day and does not work another day. Could you please assit how can i use this variable to check the count of records? If i want to put condition as Print when only count =20 then how can i print it?
