Hide text object when there is no data for current selection

[ashis]

Hi ,

I have two text objects and it has if condition based that it shows up , it is working fine as expected.

However when I select any month that has no data in my transaction table , I still see those text objects.

How do I hide the text object when there is no data in my selection (for example If I select month of december'17)

Thank you,

Ashis

[sunny_talwar]

May a condition like this:

Count(TransactionID) > 0

[Anil_Babu_Samineni · Accepted solution]

Or this? Go to Properties - Layout Tab - Enable the Condition then type like below

If(Sum(Sales) = 0, 0, 1)

[ashis]

Thank Anil for your reply. it worked.

[ashis]

Thank you for your reply Sunny, i did from Go to Properties - Layout Tab - Enable the Condition.