I am created an Inventory Software.

I have 02 Tables, Receipts and Issued

I have created a Report using CR 4.6 having following headings.

Item No.   Total Receipts     Total Issued     Balance

The total receipts is sum of total receipts from Receipts Table, itemwise.
The total issues  is sum of total issues from Receipts Table, itemwise.
The balance is Total Receipts Minus Total Issues.

I have summed up both receipts and issues in Detail and hide the detail
band.
The report is running fine but the problem is that I need only those items
having Balance greater than zero.

I tried in selection formula:

but the error occured:

This formula cannot be used because it must be evaluated later.

Now I get even those items having balance=0

Please help me.

Best Regards,

Luqman

Instead of the Record Selection Formula, try the Group Selection Formula.

HTH, Paul
--
Paul Little
San Diego, CA