Hi.
In program script, I am retrieving the each transaction (debit & credit payment) make by customer.

One of the report format I need is just show the total balance should be pay by each customer.Report will not display the customer tht no balance need to pay.

My Q is :
I manage to take out the customer no more owe the company, the problem is eventhought it not display out, but it appear as one empty line...so how do I eliminate the empty line.

my report layout :
after field : tfacr200.cuno
output express : total.m <> 0

total.m is the calculation in detail line to get the total balance owe by each customer.

Thanks.

Try round(total.m,1,4) <> 0.0000

I have found that somtime their have a total amount with 0.000000012345...

Hi hp

Where do you calculate the figure that customers owe, check for the same figure in before.layout of that particular detail or what ever layout you are using to print such lines. And if the customer balance <= 0 then use lattr.print = FALSE, this won't allow that line to print and will move to the next layout.

Vinod

Use double.cmp(total.m, 0.0, 0.0001)

before.layout:
if round(total.m,1,4) = 0.0000 Then
lattr.print = false
endif