Eliminating empty records from display

[Jananee_iNautix]

Hi,

I have a report displayed in table format .The search query currently includes and displays the records that have all the fields conatining null values in it.There is a requirement to eliminate the records that has the fields containing no values in it. For Example

Filename user server............service
1)
2) abbc ftyfe reg.............ferwe

In the above report record 1) should be eliminated from display .Is there any way to do it.Please advise.

[somesoni2]

Can you post your current search query?

[linu1988]

Try

source=test Filename!=""|table *

or

source=test NOT isnull(Filename)|table *

Thanks