I am trying to suppress a Detail record on conditions..
What I have is:
[ul]
[li]Each record is distinct on InvoiceLineID[/li]
[li]Each InvoiceLineID can have duplicate SalesOrderLineID[/li]
[li]Each SalesOrderLineID has an ExtendedCost[/li]
[li]Each SalesOrderLineID can have a different PartID[/li]
[/ul]
What I need to do is:
Look if a there is a duplicate record with same SalesOrderLineID and same PartID = "Deposit" and suppress both records if the ExtendCost negate each other (i.e. sum to 0).
Note that the Deposit for each InvoiceID will be listed consecutively in the report...
What I have is:
[ul]
[li]Each record is distinct on InvoiceLineID[/li]
[li]Each InvoiceLineID can have duplicate SalesOrderLineID[/li]
[li]Each SalesOrderLineID has an ExtendedCost[/li]
[li]Each SalesOrderLineID can have a different PartID[/li]
[/ul]
What I need to do is:
Look if a there is a duplicate record with same SalesOrderLineID and same PartID = "Deposit" and suppress both records if the ExtendCost negate each other (i.e. sum to 0).
Note that the Deposit for each InvoiceID will be listed consecutively in the report...