Records with zero value

nileshr18

I have created a report Creditor Sub Trial balance in which I have written a function GetAmount using tables Vendor and Vendor ledger entry
which retrives the record and displays it.It also shows the record with
zero values which i want to hide using footerprinted datatype which is boolean, How can I do that ?

idiot

Whatever, Body (1) - OnPreSection()
CurrReport.SHOWOUTPUT (GetAmount <> 0);

GRUBBYFANS

other method,you can write your code in OnPredataitem()

record.setfilter(field,'<>%1','');
if not record.find('-') then
curreport.skip;