Suppressing earlier record based on later record

[lrdavis]

I need to track the number of days a container is overdue to be returned. The first record shows the full container being delivered and a later record shows the empty being returned. The task is to suppress display of the first record based on later record indicating a return. In other words, the returned containers should not show at all. The number of days calculation is no problem, just the logic to suppress a container when a return has occured.

Thanks in advance.

 

[lbass]

You haven't described your fields. Assuming you have a group on {table.container} and that you have a field {table.returned} that indicates if the container has been returned, then you could create a formula {@returned}:

if isnull({table.returned}) then 0 else 1

Then go to report->edit selection formula->GROUP and enter:

sum({@returned},{table.container}) = 0

This should return all records for each container that has not been returned. If this is not how your fields are set up, please describe your fields and provide some sample data.

-LB