I have a report that tells me what has not been returned and is grouped by transaction seral number in a SN field in my transaction table, Either issues or returns in another field I call source. My quantities are taken from another table called document history in a quantity field from which the two are linked by the transaction serial number. Hence: transactions.trans_sn, transactions.source and dochistory.doc_sn, dochistory.trans_sn, dochistory.doc_num and dochistory.qty_ava. When a transaction occurs, a document number is generated, by default, in the doc_num field.
My question is, if, say an issue transaction occurs against a document number for a quantity of 5 and another occurs for a return against the same document number for, say, a quantity of 5. Now, the way I have my report written, grouped by transaction, all transactions will list, issues and returns. One record will give me an issue quantity - 5 and one a return quantity - 5. I want to calculate those issues and returns of the same doucment number so they do not show. I have tried suppress the group, even the suppressing the qty_ava field using, {fieldname} = NEXT ({fieldname), but then it supress's all records. Is there a way to calculate in a formula to do what I want, not show, and still have my other records against the document number that will still show the issues, that have not been returned? Can someone point me in the right direction?
My question is, if, say an issue transaction occurs against a document number for a quantity of 5 and another occurs for a return against the same document number for, say, a quantity of 5. Now, the way I have my report written, grouped by transaction, all transactions will list, issues and returns. One record will give me an issue quantity - 5 and one a return quantity - 5. I want to calculate those issues and returns of the same doucment number so they do not show. I have tried suppress the group, even the suppressing the qty_ava field using, {fieldname} = NEXT ({fieldname), but then it supress's all records. Is there a way to calculate in a formula to do what I want, not show, and still have my other records against the document number that will still show the issues, that have not been returned? Can someone point me in the right direction?