Remove zero before exporting to Excel.

Visi_V

Hello everyone.

Like the title says, how does i remove zero/blank lines before insert into excel.




If you see the picture with test data, zero amounts in the column "budget amount"(column 3, from left) appearing many times. I want the accounts who has zero in budget amount not to be exportet into excel, by using a boolean felt in request page. Any idea??

Thanks in advance!

sainath

Hello Visi,

Try this code on "OnAfterGetRecord Trigger"

If Amount = 0 Then
CurrentReport.Skip;

sainath

Hello Visi,

Try this code on "OnAfterGetRecord Trigger"

If Amount = 0 Then
CurrentReport.Skip;

Visi_V

Sainath:

Where in report 82 (Export to excel) should i paste the code???