Remove zero before exporting to Excel.

Visi_V · 2017-09-07

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 · 2017-09-07

Hello Visi,

Try this code on "OnAfterGetRecord Trigger"

If Amount = 0 Then
CurrentReport.Skip;

sainath · 2017-09-07

Hello Visi,

Try this code on "OnAfterGetRecord Trigger"

If Amount = 0 Then
CurrentReport.Skip;

Visi_V · 2017-09-08

Sainath:

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

Remove zero before exporting to Excel.

Best Answer

Answers

Categories